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.