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 | 
openGauss 2025-10-31 07:42:18