Poor man Audit Vault
Everyone knows how to enable database auditing .That’s for sure.But to make auditors happy is another story.One of the requirements is that all these data from the source should be stored somewhere else.. but not on source .. If you have plenty of money you can get Oracle audit wault.But if you don’t than you make your … Read more
DDL Audit trigger that sends e-mail
Found this code on google and modified it to send e-mail when DDL change on schema of interest.You can alter it to fit your needs.. First create two tables that will store DDL information:events and sqltext: DROP TABLE ddl_events; CREATE TABLE ddl_events ( eventId NUMBER(10,0), eventDate DATE, oraLoginUser VARCHAR2(30), oraDictObjName VARCHAR2(30), … Read more
