How to organize monitoring of changes in the level of user rights in MSSQL Server?

Question

Database

The point is this. There is a certain MS SQL server, conditionally one of the admins gave some rights to some of the users. It is necessary to track this and automatically send a letter to the specified address with information on who, to whom, and what rights have been filed. Are there any regular features of MSSQL itself or third-party solutions?

Answer 1

Of course you can. Read about DDL triggers.