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 | 31a89ddeb8ebe1904a4a2fc8914f577c6ceb9dee (patch) | |
| tree | e154d42562499a339932ce51997cc93f18772a64 | |
| parent | 04d2d605f3a4d0d90f35e89c66a19c338ede0dd8 (diff) | |
| download | postgresql-31a89ddeb8ebe1904a4a2fc8914f577c6ceb9dee.tar.gz postgresql-31a89ddeb8ebe1904a4a2fc8914f577c6ceb9dee.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 8903ab2fc9c..b1035d0dcab 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 |