0 - 2 of 2 tags for audit

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


In my stored procedures, I'm looking to start recording an "audit log" after each step.

So for example:

* Step 1 in my Stored Proc

DELETE FROM MyDatabase.MyTable_Step1 ALL;

INSERT INTO MyDatabase.MyTable_Step1
SELECT blah;

* Insert Audit Log for the above step

INSERT INTO MyDatabase.AuditLog(SPName, Step, Timestmp, RowsImpacted)
VALUES('MySP', 'Step 1', CURRENT_TIMESTAMMP, CountRowsImpacted() );

* Step 2 in my Stored Proc

UPDATE MyDatabase.MyTable_Step1
FROM ( SELECT 'blah' AS blah ) AS a
SET Col = a.blah