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 | bf7584e4c7f759e7584b82f9353f61ba4a9d3f21 (patch) | |
| tree | 3f9ddb33d7ff0254c556fcc20ccd42129ce0b5c8 | |
| parent | 2f1f49975f93edb59bebe2dcebecaa7e331e9d04 (diff) | |
| download | postgresql-bf7584e4c7f759e7584b82f9353f61ba4a9d3f21.tar.gz postgresql-bf7584e4c7f759e7584b82f9353f61ba4a9d3f21.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 74055a47065..116e5e88506 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 |