Create a separate grantable privilege for TRUNCATE, rather than having it be

Tom Lane <tgl@sss.pgh.pa.us>

Commit: a0b76dc662efde6e02921c2d16e06418483b7534

Author: Tom Lane <tgl@sss.pgh.pa.us>

Date: 2008-09-08T00:47:41Z

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

Files

Path	Change	+/−
doc/src/sgml/ddl.sgml	modified	+2 −2
doc/src/sgml/func.sgml	modified	+2 −2
doc/src/sgml/information_schema.sgml	modified	+7 −7
doc/src/sgml/ref/grant.sgml	modified	+19 −7
doc/src/sgml/ref/lock.sgml	modified	+3 −2
doc/src/sgml/ref/revoke.sgml	modified	+2 −2
doc/src/sgml/ref/truncate.sgml	modified	+3 −2
doc/src/sgml/user-manag.sgml	modified	+2 −2
src/backend/catalog/aclchk.c	modified	+7 −3
src/backend/catalog/information_schema.sql	modified	+10 −3
src/backend/commands/lockcmds.c	modified	+2 −2
src/backend/commands/tablecmds.c	modified	+7 −3
src/backend/utils/adt/acl.c	modified	+11 −1
src/bin/pg_dump/dumputils.c	modified	+3 −1
src/bin/psql/tab-complete.c	modified	+4 −4
src/include/catalog/catversion.h	modified	+2 −2
src/include/nodes/parsenodes.h	modified	+2 −2
src/include/utils/acl.h	modified	+4 −3
src/test/regress/expected/dependency.out	modified	+11 −11
src/test/regress/expected/privileges.out	modified	+34 −2
src/test/regress/sql/dependency.sql	modified	+1 −1
src/test/regress/sql/privileges.sql	modified	+15 −1