Thank this author by sharing:
By Gokhan Varol, 2011/02/03
The second script prints out the current permissions for Database, Schema, Object and column. It also creates the revoke script for each. I also included the class, User, objectname in the output to make filtering easier.
The first script scripts to role memberships and also the removal of the role membership.
script
Need Automated Script
drop script
script errors
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
