Session logon is directory-based

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

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
  • does not have an assigned set of directory-managed roles,
  • maps to a permanent user that has a default database-managed role, and
  • does not change the current role
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'
  • Not assigned a set of directory-managed roles,
  • Does not change the current role, and one of the following condition is true”

    Directory-based logon does not map to a permanent user

    Permanent user that the directory-based logon maps to does not have a default database-managed role

NULL
Uses a SET ROLE NONE statement
Uses a SET ROLE NULL statement