]> granicus.if.org Git - postgresql/commit
Create a separate grantable privilege for TRUNCATE, rather than having it be
authorTom Lane <tgl@sss.pgh.pa.us>
Mon, 8 Sep 2008 00:47:41 +0000 (00:47 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Mon, 8 Sep 2008 00:47:41 +0000 (00:47 +0000)
commita0b76dc662efde6e02921c2d16e06418483b7534
tree2f3038d0791a79d2230fca027ac73b5fd64f03c8
parenta26c7e3d71d65381bc60b0d0b30f03cd738fb0e9
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
22 files changed:
doc/src/sgml/ddl.sgml
doc/src/sgml/func.sgml
doc/src/sgml/information_schema.sgml
doc/src/sgml/ref/grant.sgml
doc/src/sgml/ref/lock.sgml
doc/src/sgml/ref/revoke.sgml
doc/src/sgml/ref/truncate.sgml
doc/src/sgml/user-manag.sgml
src/backend/catalog/aclchk.c
src/backend/catalog/information_schema.sql
src/backend/commands/lockcmds.c
src/backend/commands/tablecmds.c
src/backend/utils/adt/acl.c
src/bin/pg_dump/dumputils.c
src/bin/psql/tab-complete.c
src/include/catalog/catversion.h
src/include/nodes/parsenodes.h
src/include/utils/acl.h
src/test/regress/expected/dependency.out
src/test/regress/expected/privileges.out
src/test/regress/sql/dependency.sql
src/test/regress/sql/privileges.sql