Characteristics of Directory Users Mapped to Permanent Database Users - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
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 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.