16.10 - Example: Identifying Users Recently Forced Off the System - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

Use this query to identify users that were forced off the system in the past two days:

    SELECT DISTINCT UserName FROM DBC.LogOnOffX
     WHERE Event = ’Forced Off’
      AND LogDate > DATE - 3 ;