How to view last login date of users in Teradata?

UDA

How to view last login date of users in Teradata?

Hi,

We are on Teradata V2 R6.1 and would like to determine the last login timestamp of all our Teradata users. Please advise on how to obtain this information.

Thanks,
Slash1403
1 REPLY
Enthusiast

Re: How to view last login date of users in Teradata?

Try querying dbc.logonoff table.If you want to identify what queries were run,enable Access logging and query logging options and query Accesslog and other dbql tables in DBC.