8 Replies Latest reply: Jul 14, 2013 11:58 PM by sb92075 RSS

    Audting database

    yxes2013

      Hi all

       

      11.2.0.3

      Aix 6.1

       

      Which data dictionary is best to use to generate audit reports?

       

      1. Sys.aud$

      2. Dba_audit_trail

      3. Dba_audit_session

       

      Thanks a lot,

      zxy

        • 1. Re: Audting database
          JustinCave

          Whichever one(s) have the specific data that you're interested in?

           

          Presumably, you know what your "audit reports" are supposed to contain.  Since we're not part of your company and have no context, however, it's impossible for us to guess about what sort of report you're trying to write.  That makes it impossible to know which data dictionary table(s) you would need to use.

           

          Justin

          • 2. Re: Audting database
            sb92075

            yxes2013 wrote:

             

            Hi all

             

            11.2.0.3

            Aix 6.1

             

            Which data dictionary is best to use to generate audit reports?

             

            1. Sys.aud$

            2. Dba_audit_trail

            3. Dba_audit_session

             

            Thanks a lot,

            zxy

             

            which metric measures "best"

             

            answer depends upon which audit details needs to be reported.

             

            use the view that contains the details that folks want to see.

            The three above are not the only choices & a join (or 2 ) may be required.

            • 3. Re: Audting database
              yxes2013

              I thank you all,

               

              Well, the auditor wanted a report to list users login to the database from 12am-12am 1day period.

               

              Thanks

              • 4. Re: Audting database
                sb92075

                Do you know how to write a SELECT  statement from scratch without assistance from anyone here?

                 

                if so, please proceed to do so.

                • 5. Re: Audting database
                  JustinCave

                  Well, that specific report sounds like it would be easiest to write against DBA_AUDIT_SESSION.  Assuming that you have looked at what all three data dictionary tables contain, is there some reason that you don't believe that the obvious view is the right one?  Is the auditor asking for something that is not in the view?

                   

                  As others have pointed out on your multiple related threads, this will not allow you to report on the human users that logged in via a three-tier application.

                   

                  Justin

                  • 6. Re: Audting database
                    yxes2013

                    I thank you all,

                     

                    But when I count our sys.aud$ against dba_audit_session, sys.aud$ has more rows. So it might be that sys.aud$ is more

                    accurate to extract report from?

                    • 7. Re: Audting database
                      sb92075

                      yxes2013 wrote:

                       

                      I thank you all,

                       

                      But when I count our sys.aud$ against dba_audit_session, sys.aud$ has more rows. So it might be that sys.aud$ is more

                      accurate to extract report from?

                      Nothing here stops you from generating a report from contents of SYS.AUD$

                      Please proceed to do so & stop bothering us with your daily task assignments!

                      • 8. Re: Audting database
                        yxes2013

                        Ok fine, i will give correct points to  justin

                         

                        Why is the forum seem very slowwww today? Do you experienced it too? Or is it just or network? Thanks