| Author |
Message |
ak_tiredofspam@yahoo.com
*nix forums beginner
Joined: 02 May 2005
Posts: 28
|
 Posted: Mon Feb 14, 2005 6:12 pm Post subject:
Re: sequences and security
|
|
|
even if you don't grant any privileges on this sequence to anybody
else, you could have gaps.
Have you ever considered using AQ? |
|
| Back to top |
|
 |
Rauf Sarwar
*nix forums Guru
Joined: 03 May 2005
Posts: 353
|
| Posted: Mon Feb 14, 2005 6:08 pm Post subject:
Re: sequences and security
|
|
|
vertigo wrote:
| Quote: | Hello
Sequences ara available for all users.
|
Where did you get that information from?
grant select on sequence_name to this_user;
and
revoke select on sequence_name from this_user;
are both valid AFAIK.
Regards
/Rauf |
|
| Back to top |
|
|
Turkbear
*nix forums addict
Joined: 13 May 2005
Posts: 97
|
| Posted: Mon Feb 14, 2005 5:01 pm Post subject:
Re: sequences and security
|
|
|
vertigo <ax178@wp.pl> wrote:
| Quote: | Hello
Sequences ara available for all users. One sequence is very important
for me, i always increment it by 1. But what happen when other user will
increment it by a very large number - and i do not want it (it's
important for me that i am the only one who uses that sequence, and i
want be the only one who control it's value).
What can i do to be sure that only specified user can change sequence's
internal value ?
Thanx
Michal
|
Do not grant the right to alter that sequence to anyone but your user id. |
|
| Back to top |
|
|
vertigo
*nix forums addict
Joined: 23 Mar 2005
Posts: 71
|
| Posted: Mon Feb 14, 2005 4:31 pm Post subject:
sequences and security
|
|
|
Hello
Sequences ara available for all users. One sequence is very important
for me, i always increment it by 1. But what happen when other user will
increment it by a very large number - and i do not want it (it's
important for me that i am the only one who uses that sequence, and i
want be the only one who control it's value).
What can i do to be sure that only specified user can change sequence's
internal value ?
Thanx
Michal |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
