11.3. CURRENT_ROLE

Available inDSQL, PSQL

TypeVARCHAR(63)

Syntax 

  |CURRENT_ROLE

CURRENT_ROLE is a context variable containing the explicitly specified role of the currently connected user. If there is no explicitly specified role, CURRENT_ROLE is 'NONE'.

CURRENT_ROLE always represents a valid role or 'NONE'. If a user connects with a non-existing role, the engine silently resets it to 'NONE' without returning an error.

ⓘ
Note

Roles that are active by default and not explicitly specified on connect or using SET ROLE are not returned by CURRENT_ROLE. Use RDB$ROLE_IN_USE to check for all active roles.

Example 

  |if (current_role <> 'MANAGER')
  |  then exception only_managers_may_delete;
  |else
  |  delete from Customers where custno = :custno;

See alsoRDB$ROLE_IN_USE