diff options
author | Andrew Dunstan <andrew@dunslane.net> | 2011-07-11 11:12:34 -0400 |
---|---|---|
committer | Andrew Dunstan <andrew@dunslane.net> | 2011-07-11 11:12:34 -0400 |
commit | 75726307e6164673c48d6ce1d143a075b8ce18fa (patch) | |
tree | 1c75681e4e21fc4907e0f5be0c479ff2fad722a0 /doc/src | |
parent | 4240e429d0c2d889d0cda23c618f94e12c13ade7 (diff) | |
download | postgresql-75726307e6164673c48d6ce1d143a075b8ce18fa.tar.gz postgresql-75726307e6164673c48d6ce1d143a075b8ce18fa.zip |
Improve wording of documentation on default privileges.
Per recent -hackers discussion.
Diffstat (limited to 'doc/src')
-rw-r--r-- | doc/src/sgml/ref/grant.sgml | 19 |
1 files changed, 10 insertions, 9 deletions
diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index 689aba5104f..1f5fe1f41fd 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -139,15 +139,16 @@ GRANT <replaceable class="PARAMETER">role_name</replaceable> [, ...] TO <replace </para> <para> - Depending on the type of object, the initial default privileges might - include granting some privileges to <literal>PUBLIC</literal>. - The default is no public access for tables, columns, schemas, and - tablespaces; - <literal>CONNECT</> privilege and <literal>TEMP</> table creation privilege - for databases; - <literal>EXECUTE</> privilege for functions; and - <literal>USAGE</> privilege for languages. - The object owner can of course revoke these privileges. (For maximum + PostgreSQL grants default privileges on some types of objects to + <literal>PUBLIC</literal>. No privileges are granted to + <literal>PUBLIC</literal> by default on tables, + columns, schemas or tablespaces. For other types, the default privileges + granted to <literal>PUBLIC</literal> are as follows: + <literal>CONNECT</literal> and <literal>CREATE TEMP TABLE</literal> for + databases; <literal>EXECUTE</literal> privilege for functions; and + <literal>USAGE</literal> privilege for languages. + The object owner can, of course, <command>REVOKE</command> + both default and expressly granted privileges. (For maximum security, issue the <command>REVOKE</> in the same transaction that creates the object; then there is no window in which another user can use the object.) |