projects / users / gsingh / postgres.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: f687bf6) | patch
Add "pg_database_owner" default role.
authorNoah Misch <noah@leadboat.com>
Fri, 26 Mar 2021 17:42:17 +0000 (10:42 -0700)
committerNoah Misch <noah@leadboat.com>
Fri, 26 Mar 2021 17:42:17 +0000 (10:42 -0700)
commita14a0118a1fecf4066e53af52ed0f188607d0c4b
treed24b18e8c0fe2d3af805efe11e54d5718c249732tree
parentf687bf61ed4dc75ec074c387f848147da2097e13commit | diff
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
doc/src/sgml/catalogs.sgml diff | blob | blame | history
doc/src/sgml/user-manag.sgml diff | blob | blame | history
src/backend/catalog/information_schema.sql diff | blob | blame | history
src/backend/commands/user.c diff | blob | blame | history
src/backend/utils/adt/acl.c diff | blob | blame | history
src/backend/utils/cache/catcache.c diff | blob | blame | history
src/bin/psql/describe.c diff | blob | blame | history
src/include/catalog/catversion.h diff | blob | blame | history
src/include/catalog/pg_authid.dat diff | blob | blame | history
src/test/regress/expected/privileges.out diff | blob | blame | history
src/test/regress/sql/privileges.sql diff | blob | blame | history
Postgres clone for personal branches