About DBC.SessionTbl Information for Directory User Sessions - Advanced SQL Engine - Teradata Database

Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ied1556235912841.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1100
lifecycle
previous
Product Category
Teradata Vantage™
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.