]> granicus.if.org Git - postgresql/commit
Add support for privileges on types
authorPeter Eisentraut <peter_e@gmx.net>
Mon, 19 Dec 2011 22:05:19 +0000 (00:05 +0200)
committerPeter Eisentraut <peter_e@gmx.net>
Mon, 19 Dec 2011 22:05:19 +0000 (00:05 +0200)
commit729205571e81b4767efc42ad7beb53663e08d1ff
tree54081fe5cf5494bf77f0df20780b21288ba97411
parent05e992e90e49aa5bca7e2b290ab736bfec97a7c1
Add support for privileges on types

This adds support for the more or less SQL-conforming USAGE privilege
on types and domains.  The intent is to be able restrict which users
can create dependencies on types, which restricts the way in which
owners can alter types.

reviewed by Yeb Havinga
41 files changed:
doc/src/sgml/information_schema.sgml
doc/src/sgml/ref/alter_default_privileges.sgml
doc/src/sgml/ref/alter_foreign_table.sgml
doc/src/sgml/ref/alter_table.sgml
doc/src/sgml/ref/alter_type.sgml
doc/src/sgml/ref/create_aggregate.sgml
doc/src/sgml/ref/create_cast.sgml
doc/src/sgml/ref/create_domain.sgml
doc/src/sgml/ref/create_foreign_table.sgml
doc/src/sgml/ref/create_function.sgml
doc/src/sgml/ref/create_operator.sgml
doc/src/sgml/ref/create_table.sgml
doc/src/sgml/ref/create_type.sgml
doc/src/sgml/ref/grant.sgml
doc/src/sgml/ref/psql-ref.sgml
doc/src/sgml/ref/revoke.sgml
src/backend/access/common/tupdesc.c
src/backend/catalog/aclchk.c
src/backend/catalog/information_schema.sql
src/backend/catalog/pg_aggregate.c
src/backend/catalog/pg_type.c
src/backend/commands/functioncmds.c
src/backend/commands/operatorcmds.c
src/backend/commands/tablecmds.c
src/backend/commands/typecmds.c
src/backend/executor/execMain.c
src/backend/parser/gram.y
src/backend/utils/adt/acl.c
src/bin/psql/describe.c
src/bin/psql/tab-complete.c
src/include/catalog/catversion.h
src/include/catalog/pg_class.h
src/include/catalog/pg_default_acl.h
src/include/catalog/pg_proc.h
src/include/catalog/pg_type.h
src/include/nodes/parsenodes.h
src/include/parser/kwlist.h
src/include/utils/acl.h
src/include/utils/builtins.h
src/test/regress/expected/privileges.out
src/test/regress/sql/privileges.sql