administrable_role_authorizations

33.4. administrable_role_authorizations

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

Table 33-2. administrable_role_authorizations Columns

NameData TypeDescription
granteesql_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_namesql_identifierName of a role
is_grantablecharacter_dataAlways YES

Back to top

(С) Виктор Вислобоков, 2008-2010