If the session logon is directory-based, refer to 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 | |
|
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' |
|
NULL |
| Uses a SET ROLE NONE statement | |
| Uses a SET ROLE NULL statement |