9.3 CURRENT_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.