Updated on 2023-10-23 GMT+08:00

PG_DEFAULT_ACL

PG_DEFAULT_ACL records initial permissions assigned to newly created objects.

Table 1 PG_DEFAULT_ACL columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

defaclrole

oid

ID of the role associated with the permission

defaclnamespace

oid

Namespace associated with the permission (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.
  • K indicates the client master key.
  • k indicates the column encryption key.

defaclacl

aclitem[]

Access permissions that this type of object should have on creation