Database Security Products (MOSC)

MOSC Banner

Advice on the best way to AUDIT DBA activities in Oracle 12.1 EE on Windows

edited Apr 10, 2020 1:47PM in Database Security Products (MOSC) 5 commentsAnswered

We are being asked to AUDIT DBA activities to be able to prove DBAs are not DELETING / UPDATING clinical trial data in one of our databases.

The application team cannot tell us which tables to audit so I don't think auding at the object level will work.

I am leaning towards auditing everything that a person with the DBA role does and then we could hopefully filter to find activities against the application schema objects.

I tried the following but it only seems to work if you connect as SYS.

CREATE AUDIT POLICY all_actions_pol ACTIONS ALL;

AUDIT POLICY all_actions_pol by SYS;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center