16.20 - Result Value - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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