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 |