Grant options, and cascading revoke. Grant options are allowed only for
Peter Eisentraut <peter_e@gmx.net>
Grant options, and cascading revoke. Grant options are allowed only for users right now, not groups. Extension of has_foo_privileges functions to query the grant options. Extension of aclitem type to store grantor.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/func.sgml | modified | +7 −1 |
| doc/src/sgml/ref/grant.sgml | modified | +25 −18 |
| doc/src/sgml/ref/revoke.sgml | modified | +44 −23 |
| doc/src/sgml/release.sgml | modified | +2 −1 |
| src/backend/catalog/aclchk.c | modified | +88 −132 |
| src/backend/catalog/sql_features.txt | modified | +5 −5 |
| src/backend/nodes/copyfuncs.c | modified | +3 −1 |
| src/backend/nodes/equalfuncs.c | modified | +3 −1 |
| src/backend/parser/gram.y | modified | +9 −14 |
| src/backend/utils/adt/acl.c | modified | +224 −125 |
| src/bin/initdb/initdb.sh | modified | +4 −6 |
| src/bin/pg_dump/pg_dump.c | modified | +152 −90 |
| src/include/catalog/catversion.h | modified | +4 −4 |
| src/include/catalog/pg_type.h | modified | +2 −2 |
| src/include/nodes/parsenodes.h | modified | +4 −2 |
| src/include/utils/acl.h | modified | +23 −18 |
| src/test/regress/expected/privileges.out | modified | +43 −2 |
| src/test/regress/sql/privileges.sql | modified | +28 −0 |