Setting up some alerting in SQL server 2017 which get dispatched by email to certain DBAs.
Some examples of alerting I am trying to configure would be for Alert number 229 - The EXECUTE permission was denied on the object 'X'
At the moment there is no details included in the email with regards to who had their permission denied - I am wondering, is it possible to include this?
Current notifications look like:
DATE/TIME: 7/2/2018 1:29:59 PM
DESCRIPTION: The EXECUTE permission was denied on the object 'sp_Price', database 'Customisations', schema 'dbo'.