17.10 - About DBC.SessionTbl Information for Directory User Sessions - 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)
The DBC.SessionTbl logs information about each session conducted in the database. This table contains columns with directory related information.
  • The LDAP column denotes how the user for a given session is mapped. The column displays one of these options:
    • "P" appears for sessions of a directory user mapped to a permanent database user. This includes auto provisioned users because they are permanent database users.
    • "X" appears for sessions of a directory user not mapped to a permanent database user.
    • "N" appears for sessions that do not involve directory-based users, so they are not externally authenticated.
  • The UserName column displays the username for a given session. For a directory user, the username is the authcid, the logon username by which the directory authenticates the user.
  • The AuthUser column displays a URL that includes the directory and the user DN, for example:
    ‘ldap://directory1.domain1.com/uid=userX,ou=users,dc=domain1,dc=com’

    In the event users in different directories have the same name, the logged user can be isolated back to a specific directory.

For further information about the DBC.SessionTbl, see Teradata Vantage™ - Data Dictionary, B035-1092.