I have enabled SQL Data Level Auditing on a database and I'd like to be able to filter out the alerts based on the "textdata" attribute of the Event Details.
We're interested in knowing if any data is entered into the database that matches a SSN or Driver's license number.
Has anyone ever tried this or know if it is possible with the built in reporting mechanisms of this product?
Or , would it be possible to dive into the Change Auditor tables and report off of those? Or would that violate any terms of use?