pg_init_privs

The catalog pg_init_privs records information about the initial privileges of objects in the system.

Columns 5

Column	Type	Description / reference
`objoid`	`oid`	The OID of the specific object
`classoid`	`oid`	The OID of the system catalog the object is in pg_class.oid
`objsubid`	`int4`	For a table column, this is the column number (the objoid and classoid refer to the table itself). For all other object types, this column is zero.
`privtype`	`char`	A code defining the type of initial privilege of this object; see text
`initprivs`	`aclitem[]`	The initial access privileges; see Section 5.8 for details

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`objoid`	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●
`classoid`	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●
`objsubid`	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●
`privtype`	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●
`initprivs`	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●

Version history 4

Definition snapshot: english-manuals:9923276c8a1dd23f882a05bed84… · English manual source