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