Neoview SQL Reference Manual (R2.2)
USER Function
The USER function returns the username that you logged in as. If you are logged in as the role,
the role is returned. This function can be used anywhere in the query. The values returned are
string datatype VARCHAR(64).
USER
Example of USER
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.
USER Function 429