]> granicus.if.org Git - postgresql/commit
Add GRANT ON SEQUENCE syntax to support sequence-only permissions.
authorBruce Momjian <bruce@momjian.us>
Sat, 21 Jan 2006 02:16:21 +0000 (02:16 +0000)
committerBruce Momjian <bruce@momjian.us>
Sat, 21 Jan 2006 02:16:21 +0000 (02:16 +0000)
commit4789e9880148660c7126aef4fbaf5563be6ff167
tree8fb5643fbab6a7c41b36cc19409749df1ddb03ad
parent33feb55c478af5f7a4c61232729c524d69d8d965
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.
13 files changed:
doc/src/sgml/ref/grant.sgml
doc/src/sgml/ref/revoke.sgml
src/backend/catalog/aclchk.c
src/backend/catalog/pg_shdepend.c
src/backend/commands/sequence.c
src/backend/parser/gram.y
src/backend/utils/adt/acl.c
src/bin/pg_dump/dumputils.c
src/bin/pg_dump/pg_backup_archiver.c
src/bin/pg_dump/pg_dump.c
src/include/nodes/parsenodes.h
src/include/utils/acl.h
src/test/regress/expected/privileges.out