LastAccessTimeStamp column in DBC.Users

Database
N/A

LastAccessTimeStamp column in DBC.Users

I would like to cleanup users who have not signed onto Teradata in the past 6 months.

I was thinking of using the LastAccessTimeStamp column in DBC.Users however this column is not being populated and displays as a '?'.

1.) How does one turnon the recording of column LastACcessTimeStamp in DBC.Users?

2.) Would the columnn 'LogonDate' in DBC.LogonOff be more appropriate to use for cleanup of obsolete users.

Thanks,
Marius
2 REPLIES

Re: LastAccessTimeStamp column in DBC.Users

LastAccessTimeStamp is for recording the last access done on the Object and is by default not turned on.

What you should be looking to use is is the Logon/off date in the DBC.LogonOff as you correctly mentioned.
N/A

Re: LastAccessTimeStamp column in DBC.Users

Thnx Joe...Marius