Session logon is directory-based - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
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