Hi Client needs a output as Which SQL has been trigger (Insert/update/delete/drop) query in database

Hi all,

We use oracle 11g databases and I need which query did the user run since one month along with schema/usernmae,date and from which machine he has executed query. What can I do to find these information like following? If you can provide entire query then it will be great.

I tried below but not working

select b.SQL_TEXT from dba_hist_sqltext b --v$sqltext b, DBA_HIST_ACTIVE_SESS_HISTORY,v$process,v$session s,v$sqlarea sa where p.addr=s.paddr and s.username is not null and s.USERNAME in ('MS','TK','WAP','RW460Q','CMS','BBT','ADSL');