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.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, parname, paracl
- runtime verified
- false
- source
- english-manual
Definition PG 18
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.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| parname | text | Not null | The name of a configuration parameter for which privileges are granted |
| paracl | aclitem[] | Nullable | Access privileges; see Section 5.8 for details |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:67966881c691c2dbcc8e596fcf740b930d2e8b4e6047daf22eb32e1ecc894618
Text language: en · catalog-bilingual-repair:67966881c691c2dbcc8e596fcf740b930d2e8b4e6047daf22eb32e1ecc894618