Query to find when a database role's permissions were changed

339 views Asked by At

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

0

There are 0 answers