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 2024-12-26 01:07:08