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

Thread: Audit

  1. #1
    Join Date
    Jul 2001
    Posts
    45

    Angry

    Hi All,
    We have some critical report application. Some people were given the privilege to see it. But the report have some info that does not need to be printed. Is there any way we can track down who did what and when?

    Creating a view in this case will not help. Looking for tracking utilities in oracle. Can some one help? This is NT environment.
    Thanks
    Richard

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Who did what, you mean DML? Or you want to track SELECT stmt too?

  3. #3
    Join Date
    Jun 2001
    Location
    NY
    Posts
    226
    You can certainly audit by session, access to specific objects...consult Oracle documentation on Auditing from OTN, lots of useful info there.
    roukie-dba

  4. #4
    you can implement select level auditing on the tables that matter.

    once the init.ora has the audit_trail=true or OS for trace files
    you can run the following:

    audit select on schema.tablename;

    every time somebody selects from this table, an audit entry is generated.

    NOTE: watch auditing for a couple of things, inside the database the aud$ table is in the system tablespace, you might want to move it to another tbs to prevent the system tbs from filling up.
    Watch also, the performance impact for auditing. If you turn on too much auditing there can be something like a 25% perf. hit.


    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

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