51.28. pg_init_privs#
The catalogpg_init_privs records information about the initial privileges of objects in the system. There is one entry for each object in the database which has a non-default (non-NULL) initial set of privileges.
Objects can have initial privileges either by having those privileges set when the system is initialized (byinitdb) or when the object is created during aCREATE EXTENSION and the extension script sets initial privileges using theGRANT system. Note that the system will automatically handle recording of the privileges during the extension script and that extension authors need only use theGRANT andREVOKE statements in their script to have the privileges recorded. Theprivtype column indicates if the initial privilege was set byinitdb or during aCREATE EXTENSION command.
Objects which have initial privileges set byinitdb will have entries whereprivtype is'i', while objects which have initial privileges set byCREATE EXTENSION will have entries whereprivtype is'e'.
Table 51.28. pg_init_privs Columns
Column Type Description |
|---|
The OID of the specific object |
The OID of the system catalog the object is in |
For a table column, this is the column number (the |
A code defining the type of initial privilege of this object; see text |
The initial access privileges; seeSection 5.8 for details |