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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

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.