Horton

Make UPDATE and DELETE privileges distinct. Add REFERENCES and TRIGGER

Peter Eisentraut <peter_e@gmx.net>

View on postgr.es
Commit: 96147a6d1c15b7604838dcd5de5ebd771f551d96
Author: Peter Eisentraut <peter_e@gmx.net>
Date: 2001-05-27T09:59:30Z
Releases: 7.2.1 
Make UPDATE and DELETE privileges distinct.  Add REFERENCES and TRIGGER
privileges.  INSERT and COPY FROM now require INSERT (only).  Add
privileges regression test.

Files

PathChange+/−
doc/src/sgml/ref/copy.sgml modified +2 −4
doc/src/sgml/ref/create_rule.sgml modified +2 −4
doc/src/sgml/ref/create_trigger.sgml modified +2 −4
doc/src/sgml/ref/delete.sgml modified +2 −4
doc/src/sgml/ref/grant.sgml modified +182 −373
doc/src/sgml/ref/insert.sgml modified +2 −4
doc/src/sgml/ref/psql-ref.sgml modified +3 −3
doc/src/sgml/ref/revoke.sgml modified +60 −334
doc/src/sgml/ref/select.sgml modified +2 −4
doc/src/sgml/ref/update.sgml modified +2 −4
src/backend/catalog/aclchk.c modified +14 −14
src/backend/commands/command.c modified +4 −3
src/backend/commands/comment.c modified +2 −2
src/backend/commands/copy.c modified +2 −2
src/backend/commands/sequence.c modified +4 −4
src/backend/commands/trigger.c modified +5 −3
src/backend/executor/execMain.c modified +7 −8
src/backend/parser/gram.y modified +20 −12
src/backend/tcop/utility.c modified +3 −3
src/backend/utils/adt/acl.c modified +27 −19
src/include/utils/acl.h modified +17 −16
src/test/regress/expected/privileges.out added +198 −0
src/test/regress/parallel_schedule modified +1 −0
src/test/regress/pg_regress.sh modified +13 −1
src/test/regress/serial_schedule modified +2 −1
src/test/regress/sql/privileges.sql added +146 −0