git.postgresql.org Git - postgresql.git/commit

author	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 5 Oct 2009 19:24:49 +0000 (19:24 +0000)
committer	Tom Lane <tgl@sss.pgh.pa.us>
	Mon, 5 Oct 2009 19:24:49 +0000 (19:24 +0000)
commit	249724cb014bd341cf51a8c4284fca9767a556d1
tree	c165eeb00764af4ee34157d7dc1cdc8d2a23593b	tree
parent	41f89e3bbc3138d82fe26084236f9687414091e4	commit \| diff

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

48 files changed:

doc/src/sgml/catalogs.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/allfiles.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/alter_default_privileges.sgml	[new file with mode: 0644]	blob
doc/src/sgml/ref/grant.sgml		diff \| blob \| blame \| history
doc/src/sgml/ref/psql-ref.sgml		diff \| blob \| blame \| history
doc/src/sgml/reference.sgml		diff \| blob \| blame \| history
src/backend/bootstrap/bootparse.y		diff \| blob \| blame \| history
src/backend/catalog/Makefile		diff \| blob \| blame \| history
src/backend/catalog/aclchk.c		diff \| blob \| blame \| history
src/backend/catalog/dependency.c		diff \| blob \| blame \| history
src/backend/catalog/heap.c		diff \| blob \| blame \| history
src/backend/catalog/index.c		diff \| blob \| blame \| history
src/backend/catalog/pg_proc.c		diff \| blob \| blame \| history
src/backend/catalog/pg_shdepend.c		diff \| blob \| blame \| history
src/backend/catalog/toasting.c		diff \| blob \| blame \| history
src/backend/commands/cluster.c		diff \| blob \| blame \| history
src/backend/commands/tablecmds.c		diff \| blob \| blame \| history
src/backend/executor/execMain.c		diff \| blob \| blame \| history
src/backend/nodes/copyfuncs.c		diff \| blob \| blame \| history
src/backend/nodes/equalfuncs.c		diff \| blob \| blame \| history
src/backend/parser/gram.y		diff \| blob \| blame \| history
src/backend/tcop/utility.c		diff \| blob \| blame \| history
src/backend/utils/adt/acl.c		diff \| blob \| blame \| history
src/backend/utils/cache/syscache.c		diff \| blob \| blame \| history
src/bin/pg_dump/common.c		diff \| blob \| blame \| history
src/bin/pg_dump/dumputils.c		diff \| blob \| blame \| history
src/bin/pg_dump/dumputils.h		diff \| blob \| blame \| history
src/bin/pg_dump/pg_backup_archiver.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump.h		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dump_sort.c		diff \| blob \| blame \| history
src/bin/pg_dump/pg_dumpall.c		diff \| blob \| blame \| history
src/bin/psql/command.c		diff \| blob \| blame \| history
src/bin/psql/describe.c		diff \| blob \| blame \| history
src/bin/psql/describe.h		diff \| blob \| blame \| history
src/bin/psql/help.c		diff \| blob \| blame \| history
src/include/catalog/catversion.h		diff \| blob \| blame \| history
src/include/catalog/dependency.h		diff \| blob \| blame \| history
src/include/catalog/heap.h		diff \| blob \| blame \| history
src/include/catalog/indexing.h		diff \| blob \| blame \| history
src/include/catalog/pg_default_acl.h	[new file with mode: 0644]	blob
src/include/nodes/nodes.h		diff \| blob \| blame \| history
src/include/nodes/parsenodes.h		diff \| blob \| blame \| history
src/include/utils/acl.h		diff \| blob \| blame \| history
src/include/utils/syscache.h		diff \| blob \| blame \| history
src/test/regress/expected/privileges.out		diff \| blob \| blame \| history
src/test/regress/expected/sanity_check.out		diff \| blob \| blame \| history
src/test/regress/sql/privileges.sql		diff \| blob \| blame \| history

This is the main PostgreSQL git repository.

RSS Atom