16.10 - Characteristics of Directory Users Mapped to Permanent Database Users - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
English (United States)

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

Directory users mapped to a permanent Teradata Database user(s):

  • 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.