16.10 - About DBC.SessionTbl Information for Directory User Sessions - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
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:

    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 Data Dictionary.