DBC.LogOnOffV - Analytics Database - Teradata Vantage

Security Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-02
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572
lifecycle
latest
Product Category
Teradata Vantage™

The DBC.LogOnOffV view provides information about the success and duration of user sessions, in addition to LogonSource information. This view is helpful to investigate failed logon attempts.

This query returns a list of failed logon attempts that occurred in the last seven days:

SELECT LogDate,LogTime,UserName,Event
FROM DBC.LogOnOffV
WHERE Event NOT LIKE ('%Logo%') AND LogDate GT DATE - 7

ORDER BY LogDate, LogTime ;

Result:

LogDate   LogTime   UserName            Event
---------------------------------------------------------
07/07/30  08:55:22  Non-existent User   Auth Failed
07/10/21  08:59:53  BRM                 Bad Account

For more information on possible values for DBC.LogOnOffV.Event, see Teradata Vantage™ - Data Dictionary, B035-1092.