Showing posts with label Auditing. Show all posts
Showing posts with label Auditing. Show all posts
Wednesday, March 5, 2025

How to manually purge your standard audit trail

›
In this post I will show you how you can manage your audit trail using the package dbms_audit_mgmt. It can be used for all kinds of audit ...
Friday, January 8, 2021

Comparison between default traditional auditing and default unified auditing

›
Applicable to Oracle Database versions 12.1 and onwards. By default, the databases are created with "Mixed-Mode" auditing enable...
Monday, August 10, 2020

what is the difference between DBA_AUDIT_TRAIL and DBA_COMMON_AUDIT_TRAIL?

›
The difference between these views is that DBA_COMMON_AUDIT_TRAIL contains information from both standard and fine-grained auditing, while...
Tuesday, February 4, 2020

How to change configuration for your audit trail

›
This post is applicable from Oracle version 11.2 until present (Oracle 19 as per writing). Check the current settings: SELECT * FROM DB...

Why is Oracle producing .aud files for internal sys-statements?

›
I have recently been in contact with Oracle support regarding an issue where my Oracle 18c database instance is sending audit information ...
2 comments:
Thursday, August 8, 2019

How to find audit information about SELECT statements

›
This article is based on setup in a database running classical auditing in version 18.6.0.0.0, but should be possible to use in older versi...
Thursday, April 4, 2019

How to audit specific users' actions on other schemas' objects

›
This was executed on Oracle 12.2 To audit actions by users on another schema's objects, execute this: audit insert table,update tabl...
Wednesday, March 13, 2019

How to count the number of LOGONS based on audit entries in DBA_AUDIT_SESSION

›
CREATE SESSION is audited by default To get an idea of the number of sessions created by the different users, use the view DBA_AUDIT_SES...
Wednesday, February 20, 2019

How to check if fine-grained auditing (FGA) is enabled in your database

›
Use the view DBA_AUDIT_POLICIES, which "describes all fine-grained auditing policies in the database. Its columns are the same as th...
Monday, February 18, 2019

Find audit information about dropped users

›
If you have created your database with dbca, or have manually run the secconf.sql script after your database was created, the "DROP U...
Tuesday, May 22, 2018

Workaround for ORA-46372: audit file not found

›
In my environment, I had the following errors popping up in Cloud Control: ORA-46372: audit file '/u01/oracle/audit/proddb01/ora_audi...
Thursday, January 11, 2018

How to toggle between "Mixed mode" Auditing, Traditional Auditing and Unified Auditing

›
This article is applicable to Oracle database versions 12.1 and onwards. For newly created databases, mixed mode auditing is enabled by d...
Monday, December 12, 2016

How to find the last password change a user made

›
Limit the search to those users who changed their password today: select name,ctime "created", ptime "passw change time...
Wednesday, December 17, 2014

Why are statements executed by SYS not found in the DB audit trail?

›
Even if Oracles default auditing is set up, it surprised me that audit information did not appear in the audit trail, for statements that s...

How can I check which tables that are being audited in my database?

›
The experiences in this article is applicable to all Oracle versions using classic auditing setup. To check which tables are currently ...
Thursday, September 11, 2014

What constitute "default auditing" under traditional auditing?

›
From the Oracle Documentation : "When you use Database Configuration Assistant (DBCA) to create a new database, Oracle Database confi...
Friday, June 6, 2014

Why does the TIMESTAMP# column in the AUD$ table contain NULL values?

›
According to Oracle Support Note 427296.1: "In database version 10gR1 and above, the TIMESTAMP# column is obsoleted in favor of the n...
Thursday, June 5, 2014

Multiple DBIDs in AUD$

›
I wanted to test the DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL package, with use_last_arch_timestamp to TRUE, to only purge records one month older ...

Audit parameters. What do they mean - short description

›
When managing your audit trail, you will need to be familiar with these settings. Here is a short description of what they mean. SQL> ...
Friday, November 22, 2013

What is the difference between BY ACCESS and BY SESSION in Oracle Auditing?

›
The difference between BY ACCESS and BY SESSION lies in how the DBA_AUDIT_TRAIL data dictionary view records the actions that they capture:...
1 comment: