5 Replies Latest reply on Aug 25, 2017 7:06 AM by Beauty_and_dBest

    Auditing Apps & Database

    Beauty_and_dBest

      Hi ALL,

       

      EBS R12.1

      11gR2

      OL6

       

       

      Someone turned on auditing in our EBS and forgot to turned in off . This is causing  performance issues on the system.

      Is there a query in FND tables if auditing is turned on?

       

       

      Please help...

       

       

      Kind regards,

      jc

        • 1. Re: Auditing Apps & Database
          Shaik

          Hi Jc

           

          We can check the profile to check whether audit is enabled at application level:

          System Profile Option AuditTrail:Activate    if its Yes then audit is enabled

           

           

          Check below  which tables enabled for audit

          System Administrator, select Security -> AuditTrail -> Tables.

          Query the table name.

           

           

           

          Check the AUDIT_TRAIL init.ora parameter to know whether audit is enabled at db level  with below tabled values

           

          DB or TRUE

          Auditing is enabled, with all audit records stored in the database audit trial (SYS.AUD$).

          DB,EXTENDED

          As db, but the SQL_BIND and SQL_TEXT columns are also populated.

          XML

          Auditing is enabled, with all audit records stored as XML format OS files.

          XML,EXTENDED

          As xml, but the SQL_BIND and SQL_TEXT columns are also populated.

          OS

          Auditing is enabled, with all audit records directed to the operating system's audit trail.

          NONE or FALSE

          Auditing is disabled.

           

           

          Regards

          Shaik

          • 2. Re: Auditing Apps & Database
            John_K

            Do you mean EBS AuditTrail or database level auditing?

            • 3. Re: Auditing Apps & Database
              Beauty_and_dBest

              Thanks Shaik and Ora,

               

               

              I want both DB & EBS  actually , Is there table query? Is very hard to check all users profile one-by-one?

               

               

               

              Kind regards,

              • 4. Re: Auditing Apps & Database
                Shaik

                Hi JC

                 

                 

                System Profile Option AuditTrail:Activate    need to check site level , it's not for individual user.

                 

                in sql level you just check

                sql>show parameter audit_trail;

                 

                It wil display the value as i listed above table based on result you can check the audit enable or not

                 

                 

                Regards

                Shaik

                • 5. Re: Auditing Apps & Database
                  Beauty_and_dBest

                  Thanks dear ALL