pgsql: Doc: fix missing explanation of default object privileges.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Doc: fix missing explanation of default object privileges.
Date: 2017-10-11 20:57:34
Message-ID: E1e2O4M-0006tT-B4@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: fix missing explanation of default object privileges.

The GRANT reference page, which lists the default privileges for new
objects, failed to mention that USAGE is granted by default for data
types and domains. As a lesser sin, it also did not specify anything
about the initial privileges for sequences, FDWs, foreign servers,
or large objects. Fix that, and add a comment to acldefault() in the
probably vain hope of getting people to maintain this list in future.

Noted by Laurenz Albe, though I editorialized on the wording a bit.
Back-patch to all supported branches, since they all have this behavior.

Discussion: https://postgr.es/m/1507620895.4152.1.camel@cybertec.at

Branch
------
REL_10_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/fbac00a4a8d3d9ff97ceb7176fce038fea5239b5

Modified Files
--------------
doc/src/sgml/ref/grant.sgml | 20 +++++++++++++++-----
src/backend/utils/adt/acl.c | 4 +++-
2 files changed, 18 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andres Freund 2017-10-11 21:10:32 pgsql: Prevent idle in transaction session timeout from sometimes being
Previous Message Robert Haas 2017-10-11 20:00:48 pgsql: Fix mistakes in comments.