0

I didn't find any event that corresponds to tracking GRANT, REVOKE

I tried object_altered, object_deleted, object_created with no luck.

  • Can you use SQL Server Audit instead? https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-ver16 – Randy in Marin Jul 11 '22 at 18:05
  • https://learn.microsoft.com/en-us/sql/relational-databases/event-classes/audit-database-object-gdr-event-class?view=sql-server-ver16 – Randy in Marin Jul 11 '22 at 19:00

0 Answers0