diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2017-10-11 16:56:23 -0400 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2017-10-11 16:57:14 -0400 |
| commit | 28605968322b70a7efe1cc89595d1cfc557d80b9 (patch) | |
| tree | b788c8f4a7afa3f758ee31e6bc0de3c8bcf93e59 /src | |
| parent | 20d210bf5bb0d5ae37c727d364cfd810c367704a (diff) | |
| download | postgresql-28605968322b70a7efe1cc89595d1cfc557d80b9.tar.gz postgresql-28605968322b70a7efe1cc89595d1cfc557d80b9.zip | |
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
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/utils/adt/acl.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/src/backend/utils/adt/acl.c b/src/backend/utils/adt/acl.c index 0c26e44d820..fa6b792d008 100644 --- a/src/backend/utils/adt/acl.c +++ b/src/backend/utils/adt/acl.c @@ -737,7 +737,9 @@ hash_aclitem_extended(PG_FUNCTION_ARGS) * acldefault() --- create an ACL describing default access permissions * * Change this routine if you want to alter the default access policy for - * newly-created objects (or any object with a NULL acl entry). + * newly-created objects (or any object with a NULL acl entry). When + * you make a change here, don't forget to update the GRANT man page, + * which explains all the default permissions. * * Note that these are the hard-wired "defaults" that are used in the * absence of any pg_default_acl entry. |