0

For a Microsoft SQL server, is there a query that shows the history of when and who changed a database role permission?

Is there combination of system views that show the following information?

For example:

Role    Permission             Modify_Date                 Grantor Name
public  Alter any certificate  2023-08-11 12:07:50.117     domain\user  (when they selected the permission)
public  Alter any certificate  2023-08-11 12:08:00.102     domain\user  (when they removed the permission)

enter image description here

Jeremy F.
  • 1,778
  • 11
  • 51
  • 86
  • 1
    Usually not historically unless you activated it ahead of time. You could check default trace or extended events if it shows something, or db log – siggemannen Aug 11 '23 at 21:04
  • 1
    Normally SQL Server does not track this sort of audit information, it's down to you to implement it; you could use SQL Server Audit or extended events – Stu Aug 11 '23 at 21:11

0 Answers0