diff options
author | Bruce Momjian <bruce@momjian.us> | 2023-11-03 13:39:50 -0400 |
---|---|---|
committer | Bruce Momjian <bruce@momjian.us> | 2023-11-03 13:39:50 -0400 |
commit | d391f6dcc377b961628510ee7049d78032816ac0 (patch) | |
tree | bcb25f8331190b2da4ef3924d6efb886fb5c93f7 /doc/src | |
parent | 77513529420253626e41df967d54e76510782c64 (diff) | |
download | postgresql-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.sgml | 6 |
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 |