Session logon is directory-based - Advanced SQL Engine - Teradata Database

SQL Functions, Expressions, and Predicates
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1145
lifecycle
previous
Product Category
Teradata Vantage™

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