Re: User privileges on sequences

>>>>> "MG" == Mihai Gheorghiu <tanethq(at)earthlink(dot)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(at)kciLink(dot)com Rockville, MD +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera http://www.khera.org/~vivek/