database sec dis6

One reason for triggers is to perform audits. Companies with sensitive data often use the auditing

architecture for Data Manipulation Language (DML) changes. DML changes can be performed
on two level – row level and column level, also known as Fine-grained auditing (FGA). Triggers
are stored PL/SQL procedure executed automatically whenever a DML operation occurs or a
specific 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?

"Is this question part of your assignment? We can help"

ORDER NOW