# pg_default_acl

The `pg_default_acl` system catalog table stores initial privileges to be assigned to newly created objects.

Table 1. `pg_catalog.pg_default_acl`


| Name              | Type        | References         | Description                                                  |
| ----------------- | ----------- | ------------------ | ------------------------------------------------------------ |
| `oid`      | `oid`       | `pg_authid.oid`    | The object id               |
| `defaclrole`      | `oid`       | `pg_authid.oid`    | The OID of the role associated with this entry               |
| `defaclnamespace` | `oid`       | `pg_namespace.oid` | The OID of the namespace associated with this entry, or 0 if none |
| `defaclobjtype`   | `char`      |                    | Type of object this entry is for: `r` = relation (table, view), `S` = sequence, `f` = function |
| `defaclacl`       | `aclitem[]` |                    | Access privileges that this type of object should have on creation |


A pg_default_acl entry shows the initial privileges to be assigned to an object belonging to the indicated user. There are currently two types of entry: "global" entries with defaclnamespace = 0, and "per-schema" entries that reference a particular schema. 

pg_default_acl is only consulted during object creation.