Result Value

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

If you are not accessing the Teradata Database through a proxy connection, CURRENT_ROLE functions exactly like the ROLE built-in function and returns the session current role, which is the current role of the session user. For more information, see ROLE.

If you are accessing the Teradata Database through a proxy connection, then CURRENT_ROLE returns the current role of the proxy user as shown in the following table.

IF the current role for the session is … THEN the result value is …
a role set by PROXYROLE the name of the role.
the default If there is one proxy role in the CONNECT THROUGH privilege of the proxy user, the result value is the name of the role.

If there are multiple proxy roles in the CONNECT THROUGH privilege of the proxy user, the result value is ALL.

PROXYROLE=ALL ALL
PROXYROLE=NONE or NULL NULL