All Forums Database
john9 30 posts Joined 05/14
08 Oct 2014
Find user id

Hi All -
Can you please let me know is there a way that we can know who has done a DML (insert,update,delete) operation on a teradata table/view.If so could you please pass me the query.
Thanks
John

Raja_KT 1246 posts Joined 07/09
08 Oct 2014

You can query DBQL tables like dbqlogtbl,dbqlsqltbl , dbc.accesslog... dbc.qrylog

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

krishaneesh 140 posts Joined 04/13
08 Oct 2014

do you have pdcrinfo enabled?

You must sign in to leave a comment.