[EXTERNAL]-RE: [EXTERNAL]-database audit trail and unified audit trail
Date: Fri, 28 Jan 2022 18:30:51 +0000
Message-ID: <DM6PR09MB467789DD5A889A01BDADB292DF229_at_DM6PR09MB4677.namprd09.prod.outlook.com>
We have a logon trigger that turns on statement auditing for selected sessions. Looks like those are now going to the unified audit table instead of the os dest specified by the init.ora parameter. Does that make sense since unified is on?
From: Amit Grover <amitgrover27_at_gmail.com>
Sent: Friday, January 28, 2022 1:17 PM
Remove the default Unified audit policies or set up a job to clear the unified audit trail, would be two options to go.
Also check the location of the unified audit, get it moved outside of Sysaux and maybe change the table partition from default(monthly) to daily, if you do want to use it, as a start.
Best Regards
On Fri, Jan 28, 2022 at 9:14 AM Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>> wrote:
Prior to upgrading to 19c, we were generating a database audit trail.
With 19c, seems like unified audit trail is turned on.
Do we have to purge BOTH the database audit trail and the unified audit trail. The database audit trail was going to OS files.
Jeffrey Beckstrom
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
Subject: Re: [EXTERNAL]-database audit trail and unified audit trail
Amit Grover
2065966629
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 28 2022 - 19:30:51 CET