Re: User privileges on sequences

>>>>> "MG" == Mihai Gheorghiu <tanethq@earthlink.net> writes:

MG> nextval("sequence")? What about setval()? Do these involve only a SELECT to
MG> the sequence, or is it an UPDATE, or is it a DELETE and INSERT, or just an
MG> INSERT?

On my sequences, I have these privs:

GRANT INSERT,UPDATE,DELETE,SELECT on some_seq to THEUSER;

I never bothered to try limiting them.  There are only 16 combos to
try, so try them!  I think you definitely need select and update.
Don't know about the others.

--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/