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

Поиск
Список
Период
Сортировка
От tgl@svr1.postgresql.org (Tom Lane)
Тема pgsql: Add a role property 'rolinherit' which, when false, denotes that
Дата
Msg-id 20050726163830.2BA5252BD5@svr1.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: tgl@svr1.postgresql.org (Tom Lane)
Дата:
Сообщение: pgsql: Add pg_has_role() family of privilege inquiry functions modeled
Следующее
От: bklawans@pgfoundry.org (User Bklawans)
Дата:
Сообщение: bizgres - bizgres: Several minor changes: 1) Parameter name for the date