pg_init_privs

The pg_init_privs catalog provides information about initial privileges of system objects.

Column name Data type Description
objoid oid (references any OID column) The OID of the specific object.
classoid oid (references pg_class.oid) The OID of the system catalog in which the object resides.
objsubid int4 The column number if the object is a table column.
0 – For all other object types.
privtype char A code indicating the type of an initial privilege assigned to the object.
initprivs aclitem[] The initial access privileges.