pg_default_acl

The catalog pg_default_acl stores initial privileges to be assigned to newly created objects.

Columns 5

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`defaclrole`	`oid`	The OID of the role associated with this entry pg_authid.oid
`defaclnamespace`	`oid`	The OID of the namespace associated with this entry, or zero if none pg_namespace.oid
`defaclobjtype`	`char`	Type of object this entry is for: r = relation (table, view), S = sequence, f = function, T = type, n = schema, L = large object
`defaclacl`	`aclitem[]`	Access privileges that this type of object should have on creation

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`defaclrole`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`defaclnamespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`defaclobjtype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`defaclacl`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 6

Definition snapshot: english-manuals:f225e6fbc30b28ee186a921728f… · English manual source