This discussion prepares you for a pre-requisite on Project 10. In the note on page 359 in your textbook, it stated that you must turn on the auditing before implementing database audit. That is, in order to see the results of the auditing to be set up on Project 10, you need to set the initialization parameter AUDIT_TRAIL = DB. (In other words, you can still proceed to design your auditing as specified in Project 10. However, you will not see any audit output if the parameter is not set right.)

The challenge for this week is to find ways to do the following:

 

1. How to show the AUDIT_TRAIL parameter setting in your database?
2. How to set the AUDIT_TRAIL parameter to DB in your database? Be specific on your system.
3. How to make the above parameter work and verify it for your system?

Please note that your individual solution may be different depending on your Oracle database version, installation choice, and operating system. You will also have to conduct some research beyond your textbook to answer the above questions.

When you are ready, please click Discussion Board to login.