11.3CURRENT_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