Updated on 2022-06-11 GMT+08:00

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:

  • r indicates a table or view.
  • S indicates a sequence.
  • f indicates a function.
  • T indicates a type.

defaclacl

aclitem[]

Access permissions that this type of object should have on creation