PG_AUTHID v16
The PG_AUTHID view provides information about database authorization identifiers (that is, roles). A role includes users and groups.
In addition to the information in the PostgreSQL pg_authid description, EDB Postgres Advanced Server provides the following information.
| Name | Type | Description |
|---|---|---|
| rolaccountstatus | smallint | Account status of the role |
| rolcreatedblink | Boolean | Specifies whether the role is allowed to create databases link |
| rolcreatepublicdblink | Boolean | Specifies whether the role is allowed to create public databases link |
| roldroppublicdblink | Boolean | Specifies whether the role is allowed to drop public databases links |
| rolpolicyexempt | Boolean | Specifies whether the role is allowed to bypass VPD policies |
| rolprofile | oid | Object identifier for the role's profile |