OSDN Git Service

Align GRANT/REVOKE behavior more closely with the SQL spec, per discussion
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 1 Jun 2004 21:49:23 +0000 (21:49 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 1 Jun 2004 21:49:23 +0000 (21:49 +0000)
commit4b2dafcc0b1a579ef5daaa2728223006d1ff98e9
tree92ffc092eb0e4f86dfc61da16426b4c1b40b84f3
parentf35e8d843117f9e1b8929a3cce8344baef75a389
Align GRANT/REVOKE behavior more closely with the SQL spec, per discussion
of bug report #1150.  Also, arrange that the object owner's irrevocable
grant-option permissions are handled implicitly by the system rather than
being listed in the ACL as self-granted rights (which was wrong anyway).
I did not take the further step of showing these permissions in an
explicit 'granted by _SYSTEM' ACL entry, as that seemed more likely to
bollix up existing clients than to do anything really useful.  It's still
a possible future direction, though.
doc/src/sgml/ref/grant.sgml
doc/src/sgml/ref/revoke.sgml
src/backend/catalog/aclchk.c
src/backend/utils/adt/acl.c
src/include/utils/acl.h
src/include/utils/errcodes.h
src/test/regress/expected/privileges.out