Specifying Parameters to Narrow the Search of System Views - 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™

You can focus the search of a system view by specifying critical parameters in the SQL statement, for example:

SELECT a.UserName, a.LogDate, a.LogTime, StatementText, LogonSource
FROM DBC.AccessLogV AS a, DBC.LogOnOffX AS b
WHERE a.UserName = 'DBADMIN'
AND a.SessionNo = b.SessionNo
ORDER BY 2, 3 ;

This query displays the SQL statements, along with the logon IP address and date/time information, for a particular username and session number.