pg_default_acl

The pg_default_acl catalog provides information about default privileges for new objects.

Column name Data type Description
oid oid A row identifier.
defaclrole oid (references pg_authid.oid) The OID of the role associated with this entry.
defaclnamespace oid (references pg_namespace.oid) The OID of the namespace associated with this entry.
0 – None.
defaclobjtype char The object type of the entry.
The possible values are:
  • r – Relation.
  • S – Sequence.
  • f – Function.
  • T – Type.
  • n – Schema.
  • L – Large object.
defaclacl aclitem[] Access privileges that objects of this type should have upon creation.