16.20 - Session logon is directory-based - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Advanced SQL Engine
Teradata Database
March 2019
Programming Reference

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

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