35.4. administrable_role_authorizations — PostgreSQL 20devel

Supported versions: Current (18) / 17 / 16 / 15 / 14

Development versions: 19 / 20devel

Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2

Development snapshot. PostgreSQL 20devel has not been released. Content may change.

35.4. `administrable_role_authorizations`
Prev	Up	Chapter 35. The Information Schema	Home	Next

35.4. `administrable_role_authorizations` #

The view administrable_role_authorizations identifies all roles that the current user has the admin option for.

Table 35.2. administrable_role_authorizations Columns

Column Type Description
`grantee` `sql_identifier` Name of the role to which this role membership was granted (can be the current user, or a different role in case of nested role memberships)
`role_name` `sql_identifier` Name of a role
`is_grantable` `yes_or_no` Always `YES`

Column Type

Description

grantee sql_identifier

Name of the role to which this role membership was granted (can be the current user, or a different role in case of nested role memberships)

role_name sql_identifier

Name of a role

is_grantable yes_or_no

Always YES

Prev	Up	Next
35.3. `information_schema_catalog_name`	Home	35.5. `applicable_roles`

Read the upstream documentation. For corrections, first check the current manual.