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

pgsql: Create an ALTER DEFAULT PRIVILEGES command, which allows users to

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Create an ALTER DEFAULT PRIVILEGES command, which allows users to
Date: 2009-10-05 19:24:49
Message-ID: 20091005192449.4F33B753FB7@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Create an ALTER DEFAULT PRIVILEGES command, which allows users to adjust
the privileges that will be applied to subsequently-created objects.

Such adjustments are always per owning role, and can be restricted to objects
created in particular schemas too.  A notable benefit is that users can
override the traditional default privilege settings, eg, the PUBLIC EXECUTE
privilege traditionally granted by default for functions.

Petr Jelinek

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.207 -> r2.208)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.207&r2=2.208)
        reference.sgml (r1.68 -> r1.69)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/reference.sgml?r1=1.68&r2=1.69)
    pgsql/doc/src/sgml/ref:
        allfiles.sgml (r1.75 -> r1.76)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/allfiles.sgml?r1=1.75&r2=1.76)
        grant.sgml (r1.77 -> r1.78)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/grant.sgml?r1=1.77&r2=1.78)
        psql-ref.sgml (r1.229 -> r1.230)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/psql-ref.sgml?r1=1.229&r2=1.230)
    pgsql/src/backend/bootstrap:
        bootparse.y (r1.99 -> r1.100)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/bootstrap/bootparse.y?r1=1.99&r2=1.100)
    pgsql/src/backend/catalog:
        Makefile (r1.71 -> r1.72)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/Makefile?r1=1.71&r2=1.72)
        aclchk.c (r1.154 -> r1.155)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/aclchk.c?r1=1.154&r2=1.155)
        dependency.c (r1.91 -> r1.92)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/dependency.c?r1=1.91&r2=1.92)
        heap.c (r1.359 -> r1.360)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/heap.c?r1=1.359&r2=1.360)
        index.c (r1.321 -> r1.322)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c?r1=1.321&r2=1.322)
        pg_proc.c (r1.166 -> r1.167)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c?r1=1.166&r2=1.167)
        pg_shdepend.c (r1.34 -> r1.35)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_shdepend.c?r1=1.34&r2=1.35)
        toasting.c (r1.19 -> r1.20)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/toasting.c?r1=1.19&r2=1.20)
    pgsql/src/backend/commands:
        cluster.c (r1.187 -> r1.188)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c?r1=1.187&r2=1.188)
        tablecmds.c (r1.299 -> r1.300)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/tablecmds.c?r1=1.299&r2=1.300)
    pgsql/src/backend/executor:
        execMain.c (r1.329 -> r1.330)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/executor/execMain.c?r1=1.329&r2=1.330)
    pgsql/src/backend/nodes:
        copyfuncs.c (r1.438 -> r1.439)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/copyfuncs.c?r1=1.438&r2=1.439)
        equalfuncs.c (r1.361 -> r1.362)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/nodes/equalfuncs.c?r1=1.361&r2=1.362)
    pgsql/src/backend/parser:
        gram.y (r2.679 -> r2.680)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.679&r2=2.680)
    pgsql/src/backend/tcop:
        utility.c (r1.314 -> r1.315)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/tcop/utility.c?r1=1.314&r2=1.315)
    pgsql/src/backend/utils/adt:
        acl.c (r1.149 -> r1.150)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/acl.c?r1=1.149&r2=1.150)
    pgsql/src/backend/utils/cache:
        syscache.c (r1.120 -> r1.121)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/cache/syscache.c?r1=1.120&r2=1.121)
    pgsql/src/bin/pg_dump:
        common.c (r1.107 -> r1.108)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/common.c?r1=1.107&r2=1.108)
        dumputils.c (r1.48 -> r1.49)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.c?r1=1.48&r2=1.49)
        dumputils.h (r1.25 -> r1.26)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/dumputils.h?r1=1.25&r2=1.26)
        pg_backup_archiver.c (r1.175 -> r1.176)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_backup_archiver.c?r1=1.175&r2=1.176)
        pg_dump.c (r1.548 -> r1.549)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.548&r2=1.549)
        pg_dump.h (r1.157 -> r1.158)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.h?r1=1.157&r2=1.158)
        pg_dump_sort.c (r1.25 -> r1.26)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump_sort.c?r1=1.25&r2=1.26)
        pg_dumpall.c (r1.126 -> r1.127)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dumpall.c?r1=1.126&r2=1.127)
    pgsql/src/bin/psql:
        command.c (r1.207 -> r1.208)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/command.c?r1=1.207&r2=1.208)
        describe.c (r1.226 -> r1.227)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c?r1=1.226&r2=1.227)
        describe.h (r1.40 -> r1.41)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.h?r1=1.40&r2=1.41)
        help.c (r1.152 -> r1.153)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/help.c?r1=1.152&r2=1.153)
    pgsql/src/include/catalog:
        catversion.h (r1.540 -> r1.541)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.540&r2=1.541)
        dependency.h (r1.40 -> r1.41)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/dependency.h?r1=1.40&r2=1.41)
        heap.h (r1.93 -> r1.94)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/heap.h?r1=1.93&r2=1.94)
        indexing.h (r1.108 -> r1.109)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/indexing.h?r1=1.108&r2=1.109)
    pgsql/src/include/nodes:
        nodes.h (r1.226 -> r1.227)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/nodes.h?r1=1.226&r2=1.227)
        parsenodes.h (r1.402 -> r1.403)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.402&r2=1.403)
    pgsql/src/include/utils:
        acl.h (r1.108 -> r1.109)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/acl.h?r1=1.108&r2=1.109)
        syscache.h (r1.74 -> r1.75)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/syscache.h?r1=1.74&r2=1.75)
    pgsql/src/test/regress/expected:
        privileges.out (r1.47 -> r1.48)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/privileges.out?r1=1.47&r2=1.48)
        sanity_check.out (r1.40 -> r1.41)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/sanity_check.out?r1=1.40&r2=1.41)
    pgsql/src/test/regress/sql:
        privileges.sql (r1.26 -> r1.27)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/privileges.sql?r1=1.26&r2=1.27)

Added Files:
-----------
    pgsql/doc/src/sgml/ref:
        alter_default_privileges.sgml (r1.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/alter_default_privileges.sgml?rev=1.1&content-type=text/x-cvsweb-markup)
    pgsql/src/include/catalog:
        pg_default_acl.h (r1.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_default_acl.h?rev=1.1&content-type=text/x-cvsweb-markup)

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2009-10-05 23:58:49
Subject: pgsql: Unbreak doc/src/sgml maintainer-clean rule on VPATH builds.
Previous:From: User AchernowDate: 2009-10-05 19:10:48
Subject: libpqtypes - libpqtypes: updated comment in handler.c,

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