Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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)

pgsql-committers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group