Neoview SQL Reference Manual (R2.3)

CURRENT_ROLE Function
The CURRENT_ROLE function returns the role (ROLE.name) that you logged in as. This function
can be used anywhere in the query. The values returned are string datatype VARCHAR(64).
CURRENT_ROLE()
Example of CURRENT_ROLE
Logon with role of role1.role1 and with an alias of abcd.
>>SELECT CURRENT_ROLE FROM (values(1)) x(a);
(EXPR)
-------------------------
role1.role1
--- 1 row(s) selected.
>>select user from (values(1)) x(a);
(EXPR)
-------------------------
abcd
--- 1 row(s) selected.
CURRENT_ROLE Function 325