Обсуждение: pgsql: Create a separate grantable privilege for TRUNCATE, rather than
pgsql: Create a separate grantable privilege for TRUNCATE, rather than
От
tgl@postgresql.org (Tom Lane)
Дата:
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)