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?
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
