pgsql: Add a role property 'rolinherit' which, when false, denotes that

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a role property 'rolinherit' which, when false, denotes that
Date: 2005-07-26 16:38:30
Message-ID: 20050726163830.2BA5252BD5@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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)

Browse pgsql-committers by date

  From Date Subject
Next Message User Bklawans 2005-07-26 18:46:32 bizgres - bizgres: Several minor changes: 1) Parameter name for the date
Previous Message User Nwakefield 2005-07-26 01:52:18 bizgres - bizgres: Code reorg was not deployed in initial release