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 | 019317756673a5e55171918ab6a2a9a1ebf48648 (patch) | |
| tree | bf0a47e3d83cfc9eaaee63fcbf27d279f3444a87 | |
| parent | d3246a2ad80359ad0740eb2cc5c849b3e09547d9 (diff) | |
| download | postgresql-019317756673a5e55171918ab6a2a9a1ebf48648.tar.gz postgresql-019317756673a5e55171918ab6a2a9a1ebf48648.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
| -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 9eb864d7429..7f29298e436 100644 --- a/doc/src/sgml/manage-ag.sgml +++ b/doc/src/sgml/manage-ag.sgml @@ -208,6 +208,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 |