Database Security Products (MOSC)

MOSC Banner

IP address

edited Feb 4, 2011 3:03AM in Database Security Products (MOSC) 8 commentsAnswered
 I want to know IP address.

My database(ASM) version is 10.2.0.5 on aix(2 node RAC)

I given the following

SQL>ALTER SYSTEM SET audit_trail=DB_EXTENDED SCOPE=SPFILE;

SQL>shutdown immediate;

SQL>startup

SQL>show parameter audit_trail

O/P: DB_EXTENDED

SQL>audit all on schemaname.tablename by access;

From sys.aud$ table, what information we can get, can we get IP address?

Is it enough to know IP address of the person who is doing DML operations on that table?

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