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

Thread: Audit Trail

  1. #1
    Join Date
    Nov 2001
    Posts
    55
    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

    Raj

  2. #2
    Join Date
    Jan 2002
    Posts
    8

    audit

    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
    Location
    Helsinki. Finland
    Posts
    3,938

    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