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  | 
defaclacl  | aclitem[]  | Access permissions that this type of object should have on creation  | 
openGauss 2025-11-03 22:43:02