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
|