Home » RDBMS Server » Security » Is it possible to get a list of tables on which Audits are enabled (11)
Is it possible to get a list of tables on which Audits are enabled [message #582554] Fri, 19 April 2013 07:12 Go to next message
cplusplus1
Messages: 40
Registered: October 2012
Location: usa
Member
Is it possible to get a list of tables in a schema on which Audits are enabled.

Thanks a lot for the helpful info.
Re: Is it possible to get a list of tables on which Audits are enabled [message #582557 is a reply to message #582554] Fri, 19 April 2013 07:31 Go to previous messageGo to next message
Littlefoot
Messages: 19610
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Have a look at dictionary.

SQL> select * from dictionary where upper(comments) like '%AUDIT%';

TABLE_NAME                     COMMENTS
------------------------------ ------------------------------------------------------------
USER_AUDIT_SESSION             All audit trail records concerning CONNECT and DISCONNECT
USER_AUDIT_STATEMENT           Audit trail records concerning  grant, revoke, audit, noaudi
                               t and alter system

USER_AUDIT_OBJECT              Audit trail records for statements concerning objects, speci
                               fically: table, cluster, view, index, sequence,  [public] da
                               tabase 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 atleas
                               t 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 schem
                               a

USER_AUDIT_POLICY_COLUMNS      Users fine grained auditing policy columns in the database
AUDIT_ACTIONS                  Description table for audit trail action type codes.  Maps a
                               ction type numbers to action type names


11 rows selected.

SQL>


Though, why don't you take some time and read the documentation?
Re: Is it possible to get a list of tables on which Audits are enabled [message #582558 is a reply to message #582554] Fri, 19 April 2013 07:33 Go to previous message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
Hi cplusplus,

Maybe this could be related to your answer.
Please find the link.

http://www.oracle-base.com/articles/8i/auditing.php

Thanks.
Previous Topic: How can i identify Patch no ? How it is differ from patchsets no
Next Topic: Enabling Audits can they be applied on tables or the whole schema
Goto Forum:
  


Current Time: Thu Sep 18 03:25:12 CDT 2014

Total time taken to generate the page: 0.08562 seconds