On Tue, Aug 9, 2022 at 08:33:11PM +0000, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/14/manage-ag-templatedbs.html > Description: > > The documentation for creating databases from templates is incomplete, and > should mention that access privileges are not copied. So, for example, > issuing: > > create database newdb with template existingdb owner someuser; > > results in the newly-created database lacking the access privileges that > exist in the template. > > cf: https://www.postgresql.org/docs/13/manage-ag-templatedbs.html
I have created the attached patch to document this. -- Bruce Momjian <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.
[1mdiff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml[m [1mindex 192c500994..b852783a6c 100644[m [1m--- a/doc/src/sgml/manage-ag.sgml[m [1m+++ b/doc/src/sgml/manage-ag.sgml[m [36m@@ -210,7 +210,8 @@[m [mcreatedb -O <replaceable>rolename</replaceable> <replaceable>dbname</replaceable[m objects in databases. For example, if you install the procedural[m language <application>PL/Perl</application> in <literal>template1</literal>, it will[m automatically be available in user databases without any extra[m action being taken when those databases are created. [32mIt does not copy[m [32m database-level <command>GRANT</command> permissions.[m </para>[m <para>[m
