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

Thread: How to look for objects being audited?

  1. #1
    Join Date
    Mar 2001
    Posts
    61

    Question

    Hi I am trying to audit the database for looking at table usage and then cleaning up tables not being used.
    I issued the commands

    audit update table, select table
    audit delete table
    audit insert table
    audit drop any table
    audit create table

    I have not set the audit_trail to TRUE yet that is to done on sunday on scheduled shutdown of database, I want to know is there any view I can query now to see which objects will be audited when database starts up after sunday?

    Thanks in advance

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    DBA_PRIV_AUDIT_OPTS describes current system privileges being audited across the system and by user.
    DBA_OBJ_AUDIT_OPTS describes auditing options for all objects (that can be audited).

  3. #3
    Join Date
    Mar 2001
    Posts
    61
    Thanks alot akkerend! I really appreciate

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