Frequently used Tables are as follows. We have only Select DML access on data dictionary tables.
Describes in detail all information about users that the requesting user controls, including passwords.
• End User
• Teradata Database Administrator• Supervisory
Gives one row for each time the user is logged on; used as a review of accounts set by user.
• Teradata Database Administrator
• Teradata Database Security Administrator• [X]End User
Select * from DBC.SessioninfoX ==> Will give information about only that user.