Doc: fix missing explanation of default object privileges.

Tom Lane <tgl@sss.pgh.pa.us>

Commit: 8d6f4e7ec56c73f5aa225a037e63eee71a4a3108
Author: Tom Lane <tgl@sss.pgh.pa.us>
Date: 2017-10-11T20:56:49Z
Releases: 9.5.10
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

Files

PathChange+/−
doc/src/sgml/ref/grant.sgml modified +15 −5
src/backend/utils/adt/acl.c modified +3 −1

Discussion