All Forums Database
cvsanthosh 2 posts Joined 04/16
12 Jul 2016
Audit on Teradata

Need to capture users who access sensitive information in teradata database. Able to get all the required information from dbc.accesslog such as userid, date and time of login, databasename, tablename and columnname accessed. Need to add additional information as part of audit report such as
IP Addr, Whether the SQL was succesful ( Need to eliminate the query which was aborted, did not return any result etc). This information is present in dbc.QryLog / dbc.QryLogSteps. Not sure how to join AccessLog with QryLog or QryLogSteps since QueryId is not present in Accesslog.
Please help.
Thanks in advance

You must sign in to leave a comment.