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