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

Thread: Auditing database

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    Hi Dba's ::
    I want to have my database audited. I guess I need to turn on Auditing.. How do I that.. Steps and etc.., Please give all the related links and any web sites.. Thx

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Red face Refer to DBA Handbook


    You can use the Oracle DBA Handbook which goes into detail about auditing. Also, you should do a search on the archives in this site (ie: search forums). Most likely the subject has been discussed previously.

    - Magnus


  3. #3
    Join Date
    Oct 2000
    Posts
    57
    Audit schema object

    AUDIT object_privilege ON schema.object_name

    [BY SESSION [WHENEVER [NOT SUCESSFULL]
    [BY ACCESS [WHENEVER [NOT SUCESSFULL]

    eg : audit select on scott.emp by access;

    audit sql statements

    eg : audit select table whenever not sucessfull


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