One reason for triggers is to perform audits. Companies with
You Are Eligible For 15% Discount This Month!
One reason for triggers is to perform audits. Companies with sensitive data often use the auditingarchitecture for Data Manipulation Language (DML) changes. DML changes can be performedon two level – row level and column level, also known as Fine-grained auditing (FGA). Triggersare stored PL/SQL procedure executed automatically whenever a DML operation occurs or aspecific database event occurs. Oracle defines six DML events.For our discussion please consider and expand on the following questions:1. What are some of the reasons why DML actions should be audited?2. What is the difference between row level and column level auditing?3. What are the Oracle DML events? What is trigger timings?4. Are triggers supported by all database solutions? If not, what do they use instead of triggers?
Leave a Reply
Want to join the discussion?Feel free to contribute!