How to find out list of tables affected by DML operations for a given set of users

General
Highlighted
Fan

How to find out list of tables affected by DML operations for a given set of users

Im trying to write a query to find out list of tables being affected by DML operations. I joined dbqlogtbl,dbqlsqltbl and dbqlobjtabl. 

but the objecttbl is logging the table that is being used in the read part. 

for exanple below is a insert logged in the sqltable

INSERT INTO sampletable
(
acolumn,
bcolumn,
ccolumn
)
SELECT a,b,c
FROM sampletable1 CROSS JOIN
( SELECT day_of_calendar AS x FROM sys_calendar.CALENDAR WHERE x BETWEEN 1 AND 2)

 

When i join the dbqllogtable, dbqlsqltable and object table it is giving me all the 3 tables (sampletable, sampletable1, CALENDAR ) in my result.

Is there a way to get just the sampletable??

Is there a way to get just the "sampletable" from the above logged query

 

some where condition like below?

 c.sqltextinfo NOT LIKE '%from%' || TRIM(a.objecttablename) || '%with data%' --that is one of my where clause conditions