pg_parameter_acl — PostgreSQL system catalog

Summary

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.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_parameter_acl system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• oid oid
  Row identifier
• parname text
  The name of a configuration parameter for which privileges are granted
• paracl aclitem[]
  Access privileges; see ddl_priv for details

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_parameter_acl.