Find user id

Database
N/A

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

Re: Find user id

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

Re: Find user id

do you have pdcrinfo enabled?