RDB$ROLE_IN

Procedural SQL (PSQL) StatementsAggregate Functions

`RDB$ROLE_IN_USE()`

Checks if a role is active for the current connection

Result type

BOOLEAN

Syntax

RDB$ROLE_IN_USE (role_name)

Table 1. `RDB$ROLE_IN_USE` Function Parameters
Parameter	Description
role_name	String expression for the role to check.Case-sensitive, must match the role name as stored in `RDB$ROLES`

RDB$ROLE_IN_USE returns TRUE if the specified role is active for the current connection, and FALSE otherwise.Contrary to CURRENT_ROLE — which only returns the explicitly specified role — this function can be used to check for roles that are active by default, or cumulative roles activated by an explicitly specified role.

`RDB$ROLE_IN_USE` Examples

List currently active roles

select rdb$role_name
from rdb$roles
where rdb$role_in_use(rdb$role_name);

RDB$ROLE_IN_USE()

RDB$ROLE_IN_USE()

RDB$ROLE_IN_USE Examples

`RDB$ROLE_IN_USE()`

`RDB$ROLE_IN_USE` Examples