stores initial privileges to be assigned to newly created
||Row identifier (hidden attribute; must be explicitly selected)|
||The OID of the role associated with this entry|
||The OID of the namespace associated with this entry, or 0 if none|
||Type of object this entry is for:
||Access privileges that this type of object should have on creation|
pg_default_acl entry shows the
initial privileges to be assigned to an object belonging to the
indicated user. There are currently two types of entry:
defaclnamespace = 0,
and “per-schema” entries that reference a
particular schema. If a global entry is present then it
overrides the normal
hard-wired default privileges for the object type. A per-schema
entry, if present, represents privileges to be added to the global or hard-wired
Note that when an ACL entry in another catalog is null, it is
taken to represent the hard-wired default privileges for its
object, not whatever might
pg_default_acl at the moment.
pg_default_acl is only consulted
during object creation.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.