I was recently asked to “capture” which account made a possible delete/truncate operation regularly against a table in a specific database. And I landed on this article through google and found it a very useful tutorial for setting up an audit trail to watch DML actions. The most important takeaway I got is that when you set up an audit spec which will trace actions from all possible logins, the “principal” column has to be set to “public” role because every login falls into this role.
A Quick Tutorial for Auditing DML Actions in a Database
by
Tags:
Leave a Reply