If you are not accessing Vantage 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 Vantage through a proxy connection, then CURRENT_ROLE returns the current role of the proxy user as shown in the following table.
| Current Role for Session | Result Value |
|---|---|
| Set by PROXYROLE | Name of the role. |
| 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 |