Doc: clarify behavior of ALTER DEFAULT PRIVILEGES ... IN SCHEMA.
Tom Lane <tgl@sss.pgh.pa.us>
Doc: clarify behavior of ALTER DEFAULT PRIVILEGES ... IN SCHEMA. The existing text stated that "Default privileges that are specified per-schema are added to whatever the global default privileges are for the particular object type". However, that bare-bones observation is not quite clear enough, as demonstrated by the complaint in bug #16124. Flesh it out by stating explicitly that you can't revoke built-in default privileges this way, and by providing an example to drive the point home. Back-patch to all supported branches, since it's been like this from the beginning. Discussion: https://postgr.es/m/16124-423d8ee4358421bc@postgresql.org
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/ref/alter_default_privileges.sgml | modified | +25 −9 |
Documentation touched
Discussion
- BUG #16124: Altering default privileges problem 2 messages · 2019-11-18