Help Center> Data Warehouse Service (DWS)> Developer Guide (Paris Region)> System Catalogs and System Views> System Catalogs> PG_DEFAULT_ACL
Updated on 2022-07-29 GMT+08:00
View PDF

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
Parent topic: System Catalogs