DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2001


    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
    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
    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

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