On Sat, Oct 28, 2023 at 12:18:50PM -0400, Bruce Momjian wrote:
> 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.
Sorry, I attached a _colorized_ diff; here is a normal one.
--
Bruce Momjian <br...@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Only you can decide what is important to you.
diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml
index 192c500994..b852783a6c 100644
--- a/doc/src/sgml/manage-ag.sgml
+++ b/doc/src/sgml/manage-ag.sgml
@@ -210,7 +210,8 @@ createdb -O <replaceable>rolename</replaceable> <replaceable>dbname</replaceable
objects in databases. For example, if you install the procedural
language <application>PL/Perl</application> in <literal>template1</literal>, it will
automatically be available in user databases without any extra
- action being taken when those databases are created.
+ action being taken when those databases are created. It does not copy
+ database-level <command>GRANT</command> permissions.
</para>
<para>
