The session logon can be not directory-based or directory-based.
If you are accessing Vantage through a proxy connection, and you want to get the current role of the proxy user, use the CURRENT_ROLE built-in function.
Session Logon is Not Directory-Based
If the session logon is not directory-based, see the following table.
| Current Role for the Session | Result Value |
|---|---|
| Existing role | Name of the role |
| ALL | 'ALL' |
| NONE or NULL | NULL |
Session Logon is Directory-Based
If the session logon is directory-based, see the following table.
| Session | Result Value |
|---|---|
| Assigned a set of directory-managed roles and does not change the current role | 'EXTERNAL' |
| Uses a SET ROLE EXTERNAL statement | |
All of the following:
|
Name of the default role of the permanent user |
| Uses a SET ROLE role_name statement, where role_name is either a directory-managed or database-managed role | Name of the specified role |
| Uses a SET ROLE ALL statement | 'ALL' |
All of the following:
|
NULL |
| Uses a SET ROLE NONE statement | |
| Uses a SET ROLE NULL statement |