Обсуждение: pgsql: Add a role property 'rolinherit' which, when false, denotes that
pgsql: Add a role property 'rolinherit' which, when false, denotes that
От
tgl@svr1.postgresql.org (Tom Lane)
Дата:
Log Message: ----------- Add a role property 'rolinherit' which, when false, denotes that the role doesn't automatically inherit the privileges of roles it is a member of; for such a role, membership in another role can be exploited only by doing explicit SET ROLE. The default inherit setting is TRUE, so by default the behavior doesn't change, but creating a user with NOINHERIT gives closer adherence to our current reading of SQL99. Documentation still lacking, and I think the information schema needs another look. Modified Files: -------------- pgsql/doc/src/sgml: catalogs.sgml (r2.108 -> r2.109) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.108&r2=2.109) func.sgml (r1.271 -> r1.272) (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.271&r2=1.272) pgsql/src/backend/catalog: aclchk.c (r1.115 -> r1.116) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c.diff?r1=1.115&r2=1.116) system_views.sql (r1.16 -> r1.17) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.16&r2=1.17) pgsql/src/backend/commands: user.c (r1.157 -> r1.158) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/user.c.diff?r1=1.157&r2=1.158) pgsql/src/backend/nodes: copyfuncs.c (r1.311 -> r1.312) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c.diff?r1=1.311&r2=1.312) equalfuncs.c (r1.248 -> r1.249) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c.diff?r1=1.248&r2=1.249) pgsql/src/backend/parser: gram.y (r2.502 -> r2.503) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y.diff?r1=2.502&r2=2.503) keywords.c (r1.162 -> r1.163) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/keywords.c.diff?r1=1.162&r2=1.163) pgsql/src/backend/utils/adt: acl.c (r1.121 -> r1.122) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c.diff?r1=1.121&r2=1.122) pgsql/src/include/catalog: catversion.h (r1.291 -> r1.292) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.291&r2=1.292) pg_authid.h (r1.1 -> r1.2) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_authid.h.diff?r1=1.1&r2=1.2) pgsql/src/include/nodes: parsenodes.h (r1.285 -> r1.286) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h.diff?r1=1.285&r2=1.286) pgsql/src/include/utils: acl.h (r1.82 -> r1.83) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h.diff?r1=1.82&r2=1.83) pgsql/src/test/regress/expected: rules.out (r1.104 -> r1.105) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.104&r2=1.105)