Slove this Q? a. Briefly discuss database auditing. List at least four importance and at least three objectives of database audit. a. Muscat Funds is a company that provides loan to its members. A member can avail a loan not more than 10,000 OMR. Muscat Funds management wants to record and monitor any new loan granted which are more than 10,000 OMR. Write an audit trigger command for the given scenario that will include the member id, type of loan, granted loan amount, username and the date record has been added. Your solution must include the necessary SQL commands and brief explanation for each of the steps. Note: Any object created should include student ID. For example, User2_15F1234. If the user names are inappropriate, marks shall be deducted accordingly
Slove this Q?
a. Briefly discuss
objectives of database audit.
a. Muscat Funds is a company that provides loan to its members. A member can avail a
loan not more than 10,000 OMR. Muscat Funds management wants to record and
monitor any new loan granted which are more than 10,000 OMR. Write an audit
trigger command for the given scenario that will include the member id, type of loan,
granted loan amount, username and the date record has been added.
Your solution must include the necessary SQL commands and brief explanation for each
of the steps.
Note:
Any object created should include student ID. For example, User2_15F1234. If the
user names are inappropriate, marks shall be deducted accordingly
Step by step
Solved in 6 steps