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

Teradata Vantage™ - Advanced SQL Engine Security Administration

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
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.