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 |