• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_DEFAULT_ACL

PG_DEFAULT_ACL

PG_DEFAULT_ACL stores initial privileges to be assigned to 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