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?