PG_DEFAULT_ACL

PG_DEFAULT_ACL records the initial privileges assigned to the newly created objects.

Table 1 PG_DEFAULT_ACL columns

Name

Type

Description

defaclrole

oid

ID of the role associated with the permission

defaclnamespace

oid

Namespace associated with the permission; the value is 0 if no ID

defaclobjtype

"char"

Object type of the permission

defaclacl

aclitem[]

Access permissions that this type of object should have on creation