diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2012-10-04 13:41:12 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2012-10-04 13:41:12 -0400 |
| commit | 0f6d0119f2b3e0957c67e6cb5ec84e669718bd27 (patch) | |
| tree | dcdd42fe44fbea2158a1e70c23381fa7079fd434 /doc/src/sgml/ref/create_database.sgml | |
| parent | bec6e6cdfaa8987e82c328bf72cdc30d517e09f1 (diff) | |
Fix permissions explanations in CREATE DATABASE and CREATE SCHEMA docs.
These reference pages still claimed that you have to be superuser to create
a database or schema owned by a different role. That was true before 8.1,
but it was changed in commits aa1110624c08298393dfce996f7b21809d98d3fd and
f91370cd2faf1fd35a1ac74d84652a85ed841919 to allow assignment of ownership
to any role you are a member of. However, at the time we were thinking of
that primarily as a change to the ALTER OWNER rules, so the need to touch
these two CREATE ref pages got missed.
Diffstat (limited to 'doc/src/sgml/ref/create_database.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_database.sgml | 16 |
1 files changed, 5 insertions, 11 deletions
diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index c3e691a4ad3..de37f06b8e9 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -47,14 +47,6 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable> </para> <para> - Normally, the creator becomes the owner of the new database. - Superusers can create databases owned by other users, by using the - <literal>OWNER</> clause. They can even create databases owned by - users with no special privileges. Non-superusers with <literal>CREATEDB</> - privilege can only create databases owned by themselves. - </para> - - <para> By default, the new database will be created by cloning the standard system database <literal>template1</>. A different template can be specified by writing <literal>TEMPLATE @@ -81,12 +73,14 @@ CREATE DATABASE <replaceable class="PARAMETER">name</replaceable> </listitem> </varlistentry> <varlistentry> - <term><replaceable class="parameter">use_name</replaceable></term> + <term><replaceable class="parameter">user_name</replaceable></term> <listitem> <para> - The name of the database user who will own the new database, + The role name of the user who will own the new database, or <literal>DEFAULT</literal> to use the default (namely, the - user executing the command). + user executing the command). To create a database owned by another + role, you must be a direct or indirect member of that role, + or be a superuser. </para> </listitem> </varlistentry> |