17.20 - Default Session Roles for Directory Users - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

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
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
For directory users, determination of the default role is more complex:
  • All external roles mapped to the directory user are enabled.
  • If the directory user is not mapped to any roles, but mapped to a permanent database user, the default role for the mapped permanent user is enabled.
  • If the directory user is not mapped to either database roles or users, the directory user has PUBLIC privileges.
  • If you drop an external role while directory users are logged on, the logged on users with that role immediately lose the privileges granted to the role.