>>>>> "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/