Horton

Add "pg_database_owner" default role.

Noah Misch <noah@leadboat.com>

View on postgr.es
Commit: a14a0118a1fecf4066e53af52ed0f188607d0c4b
Author: Noah Misch <noah@leadboat.com>
Date: 2021-03-26T17:42:17Z
Releases: 14.0 
Add "pg_database_owner" default role.

Membership consists, implicitly, of the current database owner.  Expect
use in template databases.  Once pg_database_owner has rights within a
template, each owner of a database instantiated from that template will
exercise those rights.

Reviewed by John Naylor.

Discussion: https://postgr.es/m/20201228043148.GA1053024@rfd.leadboat.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +3 −0
doc/src/sgml/user-manag.sgml modified +15 −0
src/backend/catalog/information_schema.sql modified +8 −1
src/backend/commands/user.c modified +36 −0
src/backend/utils/adt/acl.c modified +42 −2
src/backend/utils/cache/catcache.c modified +4 −2
src/bin/psql/describe.c modified +1 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_authid.dat modified +5 −0
src/test/regress/expected/privileges.out modified +61 −0
src/test/regress/sql/privileges.sql modified +31 −0

Documentation touched

Discussion