diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2011-12-20 00:05:19 +0200 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2011-12-20 00:05:19 +0200 |
| commit | 729205571e81b4767efc42ad7beb53663e08d1ff (patch) | |
| tree | 54081fe5cf5494bf77f0df20780b21288ba97411 /doc/src/sgml/ref/create_foreign_table.sgml | |
| parent | 05e992e90e49aa5bca7e2b290ab736bfec97a7c1 (diff) | |
| download | postgresql-729205571e81b4767efc42ad7beb53663e08d1ff.tar.gz postgresql-729205571e81b4767efc42ad7beb53663e08d1ff.zip | |
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
Diffstat (limited to 'doc/src/sgml/ref/create_foreign_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_foreign_table.sgml | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 7f1cc4264db..2113d001b08 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -52,6 +52,11 @@ CREATE FOREIGN TABLE [ IF NOT EXISTS ] <replaceable class="PARAMETER">table_name the foreign table. Therefore, foreign tables cannot have the same name as any existing data type in the same schema. </para> + + <para> + To be able to create a table, you must have <literal>USAGE</literal> + privilege on all column types. + </para> </refsect1> <refsect1> |