Hi Team,

One my team member has provide some permissions to user on few database of an instance.

I need to find which are the permissions have been provided on all the databases of an instance. I need the customized script to find this and also that should provide the revoke commands as well.

Thanks
Kumar

No duplicate posts please, avoid this

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/f5c368b6-1f4f-4535-9384-48601057a112/find-particular-database-role-permission-on-all-the-databases-of-an-instance?forum=sqldatabaseengine

Hi Shanky,

It is not a duplicate post. It is different from post which you mentioned.

I want to know which are permission my team member has provided to the user account.

Thanks
Kumar

this?

http://consultingblogs.emc.com/jamiethomson/archive/2007/02/09/SQL-Server-2005_3A00_-View-all-permissions--_2800_2_2900_.aspx

http://sqlity.net/en/2584/script-database-permissions/

Hi All,

Let me give more details on my requirement. I want to know the modified (added/removed) permissions of an existing account.

There is a user ABCD account which had datareader permission. Now my team member has provided ddladmin permission to ABCD account. Now i want to track permissions provided by my team member on this existing user account.

Thanks
Kumar

If you had a previous script of permissions,  you can compare it with new one (after user's modification)