pgsql: Add GRANT ON SEQUENCE syntax to support sequence-only

From: momjian(at)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add GRANT ON SEQUENCE syntax to support sequence-only
Date: 2006-01-21 02:16:21
Message-ID: 20060121021621.A650C9DC854@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
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.

Modified Files:
--------------
pgsql/doc/src/sgml/ref:
grant.sgml (r1.50 -> r1.51)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/grant.sgml.diff?r1=1.50&r2=1.51)
revoke.sgml (r1.35 -> r1.36)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/revoke.sgml.diff?r1=1.35&r2=1.36)
pgsql/src/backend/catalog:
aclchk.c (r1.123 -> r1.124)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.123&r2=1.124)
pg_shdepend.c (r1.6 -> r1.7)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_shdepend.c.diff?r1=1.6&r2=1.7)
pgsql/src/backend/commands:
sequence.c (r1.126 -> r1.127)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/sequence.c.diff?r1=1.126&r2=1.127)
pgsql/src/backend/parser:
gram.y (r2.521 -> r2.522)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.521&r2=2.522)
pgsql/src/backend/utils/adt:
acl.c (r1.129 -> r1.130)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c.diff?r1=1.129&r2=1.130)
pgsql/src/bin/pg_dump:
dumputils.c (r1.24 -> r1.25)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.c.diff?r1=1.24&r2=1.25)
pg_backup_archiver.c (r1.118 -> r1.119)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup_archiver.c.diff?r1=1.118&r2=1.119)
pg_dump.c (r1.426 -> r1.427)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c.diff?r1=1.426&r2=1.427)
pgsql/src/include/nodes:
parsenodes.h (r1.298 -> r1.299)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.298&r2=1.299)
pgsql/src/include/utils:
acl.h (r1.91 -> r1.92)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.91&r2=1.92)
pgsql/src/test/regress/expected:
privileges.out (r1.32 -> r1.33)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/privileges.out.diff?r1=1.32&r2=1.33)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2006-01-21 04:38:21 pgsql: Repair longstanding bug in slru/clog logic: it is possible for
Previous Message Tom Lane 2006-01-20 22:46:41 pgsql: Replace bitwise looping with bytewise looping in hemdistsign and