aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2023-11-03 13:39:50 -0400
committerBruce Momjian <bruce@momjian.us>2023-11-03 13:39:50 -0400
commitd391f6dcc377b961628510ee7049d78032816ac0 (patch)
treebcb25f8331190b2da4ef3924d6efb886fb5c93f7 /doc/src
parent77513529420253626e41df967d54e76510782c64 (diff)
downloadpostgresql-d391f6dcc377b961628510ee7049d78032816ac0.tar.gz
postgresql-d391f6dcc377b961628510ee7049d78032816ac0.zip
doc: CREATE DATABASE doesn't copy db-level perms. from template
Reported-by: david@kapitaltrading.com Discussion: https://postgr.es/m/166007719137.995877.13951579839074751714@wrigleys.postgresql.org Backpatch-through: 11
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/manage-ag.sgml6
1 files changed, 6 insertions, 0 deletions
diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml
index 192c5009945..f9fe47b6a29 100644
--- a/doc/src/sgml/manage-ag.sgml
+++ b/doc/src/sgml/manage-ag.sgml
@@ -214,6 +214,12 @@ createdb -O <replaceable>rolename</replaceable> <replaceable>dbname</replaceable
</para>
<para>
+ However, <command>CREATE DATABASE</command> does not copy database-level
+ <command>GRANT</command> permissions attached to the source database.
+ The new database has default database-level permissions.
+ </para>
+
+ <para>
There is a second standard system database named
<literal>template0</literal>.<indexterm><primary>template0</primary></indexterm> This
database contains the same data as the initial contents of