Database Security Products (MOSC)

MOSC Banner

Read .aud files

edited Mar 11, 2020 11:59AM in Database Security Products (MOSC) 7 commentsAnswered

Hi All

I have enabled database auditing to the filesystem.  My requirements are the following:

. To provide file logs of:
1. DB login with time; source machine;
2. DDL changes
3. SYS activity
4. Failed logins

So I turned on auditing like this:

ALTER SYSTEM SET audit_trail=OS SCOPE=SPFILE;

alter system set audit_file_dest='/oraaudit01/' scope=spfile;

alter system set audit_sys_operations=true scope=spfile;

audit alter any table by access;

audit create any table by access;

audit drop any table by access;

audit Create any procedure by access;

audit Drop any procedure by access;

audit Alter any procedure by access;

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