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
06-27-2001, 10:54 AM
akkerend
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).