16th June 2022: PostgreSQL 14.4 Released!
Development Versions: 15 / devel
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

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

Description

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