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.