Carol Walter написа:
Hello,
I've had trouble several times when granting permissions on tables when
I had not also granted permission to the sequence. The sequences may
only have select, insert, and usage privileges. I can guess that when I
grant select privileges on a table, I need to grant select privileges to
the sequence and I can guess that if I grant insert privileges to a
table I need to grant the insert privilege to the sequence. I don't
know when to usage and I don't know what privileges, if any, I need to
grant to the sequence if I'm going to give delete, update, or references
privileges on the tables.
[...]
Reading the documentation:
- if you only grant SELECT on the table in question - no privileges are
needed for the linked sequence;
- for normal usage (selects, inserts, updates, deletes) - the USAGE
privilege seems quite handy;
- when you need to grant full access to a sequence (rare case) - both
SELECT and UPDATE;
- UPDATE, DELETE and REFERENCES privileges on the table(s) are not
related to the privileges of the corresponding sequence;
--
Milen A. Radev
