9.3CURRENT_ROLE

Available inDSQL, PSQL

Syntax

  |CURRENT_ROLE

TypeVARCHAR(31)

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

Example

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

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.