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-0006tR-Ai@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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/28605968322b70a7efe1cc89595d1cfc557d80b9

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.