what is auditing in oracle 11g?


Please briefly explain why you feel this question should be reported .


i need to kw about auditing in oracle 11g.

in progress 0
Oracle 1 week 1 Answer 34 views 0

Answer ( 1 )

  1. rg123

    Please briefly explain why you feel this answer should be reported .


    What Is Auditing?
    Auditing is the monitoring and recording of selected user database actions, from both database users and nondatabase users. You can base auditing on individual actions, such as the type of SQL statement executed, or on combinations of data that can include the user name, application, time, and so on. You can audit both successful and failed activities. To use auditing, you enable it, and then configure what must be audited. The actions that you audit are recorded in either data dictionary tables or in operating system files.

    Oracle recommends that you enable and configure auditing. Auditing is an effective method of enforcing strong internal controls so that your site can meet its regulatory compliance requirements, as defined in the Sarbanes-Oxley Act. This enables you to monitor business operations, and find any activities that may deviate from company policy. Doing so translates into tightly controlled access to your database and the application software, ensuring that patches are applied on schedule and preventing ad hoc changes. By enabling auditing by default, you can generate an audit record for audit and compliance personnel. Be selective with auditing and ensure that it meets your business compliance needs.
    From : https://docs.oracle.com/cd/E11882_01/network.112/e36292/auditing.htm#DBSEG340

Leave an answer


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>