PostgreSQL

37.4. `administrable_role_authorizations`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.4. `administrable_role_authorizations`

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

Table 37.2. administrable_role_authorizations Columns

Name Data Type Description

Name	Data 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`

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
37.3. `information_schema_catalog_name`	Home	37.5. `applicable_roles`

37.3. information_schema_catalog_name

37.5. applicable_roles