DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Audit Trail

  1. #1
    Join Date
    Nov 2001
    I have a requirement from one of my client to track all the users logged into the oracle instance, what time, terminal number, how long connection used, which all tables modified etc this has to be tracked for DBA users too.

    Is there a way we can find all these information from Catalog tables ?

    Please help me.

    ThanX a lot in advance


  2. #2
    Join Date
    Jan 2002


    you have to enable audit for database
    see Oracle administration guide / Auditing database use

    SYS.AUD$ - name of view where audit store information

    hope this help.

  3. #3
    Join Date
    Jun 2001
    Helsinki. Finland

    Re: audit

    Most of all what his client wants can be achieved only by auditing. Some triggers might have to be made. But they want to audit the DBAs too? DBAs can always disable the triggers or delete from AUD$, etc...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.