Add GRANT ON SEQUENCE syntax to support sequence-only permissions.
Bruce Momjian <bruce@momjian.us>
Add GRANT ON SEQUENCE syntax to support sequence-only permissions. Continue to support GRANT ON [TABLE] for sequences for backward compatibility; issue warning for invalid sequence permissions. [Backward compatibility warning message.] Add USAGE permission for sequences that allows only currval() and nextval(), not setval(). Mention object name in grant/revoke warnings because of possible multi-object operations.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/grant.sgml | modified | +11 −2 |
| doc/src/sgml/ref/revoke.sgml | modified | +8 −1 |
| src/backend/catalog/aclchk.c | modified | +107 −18 |
| src/backend/catalog/pg_shdepend.c | modified | +19 −2 |
| src/backend/commands/sequence.c | modified | +7 −4 |
| src/backend/parser/gram.y | modified | +8 −1 |
| src/backend/utils/adt/acl.c | modified | +5 −1 |
| src/bin/pg_dump/dumputils.c | modified | +26 −18 |
| src/bin/pg_dump/pg_backup_archiver.c | modified | +4 −4 |
| src/bin/pg_dump/pg_dump.c | modified | +3 −2 |
| src/include/nodes/parsenodes.h | modified | +3 −2 |
| src/include/utils/acl.h | modified | +3 −1 |
| src/test/regress/expected/privileges.out | modified | +3 −3 |