|
Re: Traditional auditing: how to query existing audits? [message #689789 is a reply to message #689788] |
Mon, 22 April 2024 15:28 |
|
Michel Cadot
Messages: 68731 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> col table_name format a30
SQL> col comments format a80
SQL> select table_name, comments from dict where table_name like 'DBA%' and lower(comments) like '%audit%' order by 1;
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------------------------------------
DBA_AUDIT_EXISTS Lists audit trail entries produced by AUDIT NOT EXISTS and AUDIT EXISTS
DBA_AUDIT_MGMT_CLEANUP_JOBS The view displays the currently configured audit trail purge jobs
DBA_AUDIT_MGMT_CONFIG_PARAMS The view displays the currently configured audit trail properties that are defin
ed by the DBMS_AUDIT_MGMT PL/SQL package
DBA_AUDIT_MGMT_LAST_ARCH_TS The Last Archive Timestamps set for the Audit Trail Clean up
DBA_AUDIT_OBJECT Audit trail records for statements concerning objects, specifically: table, clus
ter, view, index, sequence, [public] database link, [public] synonym, procedure
, trigger, rollback segment, tablespace, role, user
DBA_AUDIT_POLICIES Fine grained auditing policies in the database
DBA_AUDIT_POLICY_COLUMNS All fine grained auditing policy columns in the database
DBA_AUDIT_SESSION All audit trail records concerning CONNECT and DISCONNECT
DBA_AUDIT_STATEMENT Audit trail records concerning grant, revoke, audit, noaudit and alter system
DBA_AUDIT_TRAIL All audit trail entries
DBA_COMMON_AUDIT_TRAIL Combined Standard and Fine Grained audit trail entries
DBA_FGA_AUDIT_TRAIL All fine grained audit event logs
DBA_OBJ_AUDIT_OPTS Auditing options for all tables and views with atleast one option set
DBA_PRIV_AUDIT_OPTS Describes current system privileges being audited across the system and by user
DBA_STMT_AUDIT_OPTS Describes current system auditing options across the system and by user
DBA_XS_AUDIT_POLICY_OPTIONS Describes auditing options defined under all XS security specific
audit policies
DBA_XS_ENABLED_AUDIT_POLICIES Describes all XS related audit policy's enablement to users
DBA_XS_ENB_AUDIT_POLICIES Synonym for DBA_XS_ENABLED_AUDIT_POLICIES
|
|
|
Re: Traditional auditing: how to query existing audits? [message #689790 is a reply to message #689789] |
Mon, 22 April 2024 16:01 |
|
Darth Waiter
Messages: 78 Registered: October 2020
|
Member |
|
|
So, is it this?
Michel Cadot wrote on Mon, 22 April 2024 15:28DBA_AUDIT_POLICIES Fine grained auditing policies in the database
I read about that view but the note got me confused: it says in negative that:
Quote:When unified auditing is enabled in Oracle Database, the audit records are populated in the new audit trail
The records part confuses me because it is the audits themselves that I am looking for, not audit records.
[Updated on: Mon, 22 April 2024 16:03] Report message to a moderator
|
|
|
|
|
|
Re: Traditional auditing: how to query existing audits? [message #689807 is a reply to message #689805] |
Fri, 26 April 2024 12:37 |
|
Michel Cadot
Messages: 68731 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> col parameter format a30
SQL> col value format a30
SQL> select * from v$option where lower(parameter) like '%audit%' order by 1;
PARAMETER VALUE CON_ID
------------------------------ ------------------------------ ----------
Fine-grained Auditing TRUE 0
Unified Auditing FALSE 0
Check the last line.
|
|
|