Find user id

Database
Enthusiast

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

2 REPLIES
Enthusiast

Re: Find user id

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

Enthusiast

Re: Find user id

do you have pdcrinfo enabled?