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

Teradata Vantage™ - SQL Functions, Expressions, and Predicates
Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
kby1472250656485

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