Oracle Database 12.1.0.2
RHEL 7.4
Hello,
I would like to know how do I find a user who dropped an object or another user? I used the command below by no luck
SQL> desc dba_TAB_MODIFICATIONS
Name Null? Type
----------------------------------------- -------- ----------------------------
TABLE_OWNER VARCHAR2(128)
TABLE_NAME VARCHAR2(128)
PARTITION_NAME VARCHAR2(128)
SUBPARTITION_NAME VARCHAR2(128)
INSERTS NUMBER
UPDATES NUMBER
DELETES NUMBER
TIMESTAMP DATE
TRUNCATED VARCHAR2(3)
DROP_SEGMENTS NUMBER
SQL> AUDIT DELETE ANY TABLE BY BIREPORT;
Audit succeeded.
SQL> AUDIT DROP ANY TABLE BY BIREPORT;
Audit succeeded.
SQL> AUDIT DROP ANY TABLE BY BIREPORT; //includes truncate
Audit succeeded.
SQL> commit;
Commit complete.
SQL> AUDIT DROP USER by BIREPORT;
Audit succeeded.
SQL> commit;
Commit complete.
Kindly advise.
Thanks,
Joe