Characteristics of Directory Users Mapped to Permanent Database Users - Analytics Database - Teradata Vantage

Security Administration

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-07-11
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1100
lifecycle
latest
Product Category
Teradata Vantage™

Mapped directory users function in much the same way as the permanent Teradata Vantage users to which they are mapped.

Directory users mapped to a permanent Vantage users:

  • Inherit access privileges, roles, and profile settings from the permanent user. If the directory user is mapped to more than one database user, logons must specify user=username in the .logdata statement to identify the operant user, profile, and default role.
  • Inherit the spool and temp space available to the permanent user, unless also mapped to a profile object, in which case the mapped profile takes precedence.
  • Can be mapped to role objects in addition to the roles inherited from mappings to database users.
  • Must use the SET ROLE statement (within a session) to enable any roles other than the default role inherited from the operant permanent user.