Supported Versions: Current (16) / 15
Development Versions: 17 / devel

53.36. pg_parameter_acl #

The catalog pg_parameter_acl records configuration parameters for which privileges have been granted to one or more roles. No entry is made for parameters that have default privileges.

Unlike most system catalogs, pg_parameter_acl is shared across all databases of a cluster: there is only one copy of pg_parameter_acl per cluster, not one per database.

Table 53.36. pg_parameter_acl Columns

Column Type


oid oid

Row identifier

parname text

The name of a configuration parameter for which privileges are granted

paracl aclitem[]

Access privileges; see Section 5.7 for details

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.