pgsql: Create a separate grantable privilege for TRUNCATE, rather than

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create a separate grantable privilege for TRUNCATE, rather than
Date: 2008-09-08 00:47:41
Message-ID: 20080908004741.6EDE67545A3@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Create a separate grantable privilege for TRUNCATE, rather than having it be
always owner-only. The TRUNCATE privilege works identically to the DELETE
privilege so far as interactions with the rest of the system go.

Robert Haas

Modified Files:
--------------
pgsql/doc/src/sgml:
ddl.sgml (r1.82 -> r1.83)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ddl.sgml?r1=1.82&r2=1.83)
func.sgml (r1.445 -> r1.446)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.445&r2=1.446)
information_schema.sgml (r1.33 -> r1.34)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/information_schema.sgml?r1=1.33&r2=1.34)
user-manag.sgml (r1.39 -> r1.40)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/user-manag.sgml?r1=1.39&r2=1.40)
pgsql/doc/src/sgml/ref:
grant.sgml (r1.70 -> r1.71)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/grant.sgml?r1=1.70&r2=1.71)
lock.sgml (r1.48 -> r1.49)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/lock.sgml?r1=1.48&r2=1.49)
revoke.sgml (r1.47 -> r1.48)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/revoke.sgml?r1=1.47&r2=1.48)
truncate.sgml (r1.27 -> r1.28)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/truncate.sgml?r1=1.27&r2=1.28)
pgsql/src/backend/catalog:
aclchk.c (r1.147 -> r1.148)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c?r1=1.147&r2=1.148)
information_schema.sql (r1.45 -> r1.46)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/information_schema.sql?r1=1.45&r2=1.46)
pgsql/src/backend/commands:
lockcmds.c (r1.18 -> r1.19)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/lockcmds.c?r1=1.18&r2=1.19)
tablecmds.c (r1.265 -> r1.266)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.265&r2=1.266)
pgsql/src/backend/utils/adt:
acl.c (r1.140 -> r1.141)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c?r1=1.140&r2=1.141)
pgsql/src/bin/pg_dump:
dumputils.c (r1.40 -> r1.41)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.c?r1=1.40&r2=1.41)
pgsql/src/bin/psql:
tab-complete.c (r1.171 -> r1.172)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/tab-complete.c?r1=1.171&r2=1.172)
pgsql/src/include/catalog:
catversion.h (r1.483 -> r1.484)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.483&r2=1.484)
pgsql/src/include/nodes:
parsenodes.h (r1.374 -> r1.375)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.374&r2=1.375)
pgsql/src/include/utils:
acl.h (r1.103 -> r1.104)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h?r1=1.103&r2=1.104)
pgsql/src/test/regress/expected:
dependency.out (r1.7 -> r1.8)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/dependency.out?r1=1.7&r2=1.8)
privileges.out (r1.38 -> r1.39)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/privileges.out?r1=1.38&r2=1.39)
pgsql/src/test/regress/sql:
dependency.sql (r1.4 -> r1.5)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/dependency.sql?r1=1.4&r2=1.5)
privileges.sql (r1.20 -> r1.21)
(http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/privileges.sql?r1=1.20&r2=1.21)

Browse pgsql-committers by date

  From Date Subject
Next Message Dave Page 2008-09-08 07:45:25 pginstaller - web: Correct misleading text that states CREATESERVICEUSER
Previous Message Tom Lane 2008-09-08 00:22:56 pgsql: Support set-returning functions in the target lists of Agg and