Identify User - Deleted Records

Database
Enthusiast

Identify User - Deleted Records

Hi All,
Is there any way to Identify the User who performed "Delete" operation on a Particular Table. I have tried in the QueryText Column of the DBC.QryLog, but it displays only the last two days of transaction details. Is there any other way of doing it?

Cheers,
Mm
1 REPLY
Enthusiast

Re: Identify User - Deleted Records

If your shop maintains the DBQL information in PMCP databases, you might find stuff there for the past days... you should be able to find it from PMCPINFO.DBQL* views ...