Is there any way how to know "Who did change the permission on users"


  • who give read permission or owner on a database for a user?

Using SQL Server 2014

  • 1
    Please tag your DBMS (version included). – McNets Mar 5 '18 at 10:12
  • Please see this post. I think this answers your question. – SqlWorldWide Mar 7 '18 at 2:01

You can find sys.database_permissions for all the permissions of all objects in database including who did grant permission.

| improve this answer | |
  • EXECUTE AS USER = 'UserName'; SELECT * FROM fn_my_permissions('YourSchema.TablaName', 'OBJECT') ORDER BY subentity_name, permission_name ; REVERT; GO – Pankaj Kumar Mar 13 '18 at 9:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.