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
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).
Thanks alot akkerend! I really appreciate