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

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.