List of Tables on which Audits are Enabled

How to get a list of tables in a schema on which Audits are enabled.

SQL> select * from dictionary where upper(comments) like '%AUDIT%';
USER_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT  Audit trail records concerning  grant, revoke, audit, no audit and alter system
USER_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, cluster, view, index, sequence,  [public] database link, [public] synonym, procedure, trigger, rollback segment, tablespace, role, user
USER_AUDIT_TRAIL Audit trail entries relevant to the user
USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views with at least one option set
ALL_DEF_AUDIT_OPTS Auditing options for newly created objects
ALL_AUDIT_POLICIES All fine grained auditing policies in the database
ALL_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
USER_AUDIT_POLICIES All fine grained auditing policies for objects in user schema
USER_AUDIT_POLICY_COLUMNS Users fine grained auditing policy columns in the database
AUDIT_ACTIONS Description table for audit trail action type codes.  Maps action type numbers to action type names

11 rows selected.


Oracle Database

Also read:

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips

All the site contents are Copyright © and the content authors. All rights reserved.
All product names are trademarks of their respective companies.
The site is not affiliated with or endorsed by any company listed at this site.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of or the content authors.