Identify user dropping column in a table
It is a 10.2.0.3 database. Three or more developers are sharing the same schema owner login. One of them has dropped a column from a table. Auditing is not enabled in the database.
NAME VALUE
audit_sys_operations FALSE
audit_file_dest /apps/oracle/OraHome/admin/db3/adump
audit_syslog_level
audit_trail NONE
select * from dba_stmt_audit_opts where user_name='USER1';
USER_NAME PROXY_NAME AUDIT_OPTION SUCCESS FAILURE
--------------- ---------- ---------------------------------------- ---------- ----------
USER1 CREATE SESSION BY ACCESS BY ACCESS
Based on above details if whenever 'user1' tries to login, there should be some sort of audit information. But i couldn't find any data in data dictionary tables related to auditing.
I tried to use log miner but it only identifies DML operations.
Is there a way to find out which user session did it. I mean is there a way to find the IP Address or terminal from which the DDL was executed.
Thanks in advance...