Briefly describe what audit guideline we need to follow Ans Define what you

Briefly describe what audit guideline we need to

This preview shows page 2 - 4 out of 4 pages.

Briefly describe what audit guideline we need to follow? Ans:Define what you want to audit:Audit users, statements, or objects.Statement executions.Successful statement executions, unsuccessful statement executions or both.8Briefly describe no matter if database auditing is enabled, the DBMS always recordsome database operation into operating system audit trail, and they are?Ans:Audit records will not be written to the audit trail unless the DBA has set theAUDIT_TRAIL parameter to DB or OS. Although the SQL statements AUDIT andNOAUDIT can be used at any time, records will only be written to the audit trail if theDBA has set the AUDIT_TRAIL parameter in the initialization file.
Image of page 2
9Briefly describe what are statement auditing, privilege auditing and schema objectauditing?Ans:Statement auditing: This is the selective auditing of SQL statements, not the specificschema objects on which it operates. For example, AUDIT TABLE tracks several DDLstatements regardless of the table on which they are issued. You can set statementauditing to audit selected users or every user in the database.Privilege auditing: This is the selective auditing of system privileges to performcorresponding actions, such as AUDIT CREATE ANY TRIGGER. You can set privilegeauditing to audit a selected user or every user in the database.Schema object auditing: This is the selective auditing of specific statements on aparticular schema object, such as AUDIT SELECT ON HR.EMPLOYEES Schemaobject auditing always applies to all users of the database.10Briefly describe what is value-base auditing?Ans:Database auditing cannot record column values. If the changes to database columns needto be tracked and column values need to be stored for each change, useapplication auditing. Application auditing can be done either through client code, storedprocedures,or database triggers.
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 4 pages?

  • Spring '16
  • audit trail, DBMS Auditing function

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes