Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

32.4. applicable_roles

The view applicable_roles identifies all groups that the current user is a member of. (A role is the same thing as a group.) Generally, it is better to use the view enabled_roles instead of this one; see also there.

Table 32-2. applicable_roles Columns

Name Data Type Description
grantee sql_identifier Always the name of the current user
role_name sql_identifier Name of a group
is_grantable character_data Applies to a feature not available in PostgreSQL