Hi all,
This updated v2.1 includes a fix for the schema permissions at the DB level. I hope you continue to find this script as useful as I do.
2.0 Notes:
2.0 is VERY similar to v1 which is posted at http://www.sqlservercentral.com/scripts/Security/71562/
A few fixes were put in based on feedback received by the community. I looped the code with a cursor from a recommendation by William Soranno, and fixed a SCHEMA_NAME() reference per a find by karthik.catchme.
To reiterate the function of the script:
I hadn't been able to locate a script that would give the user role permissions and object-level permissions, so I went through the GUI and used profiler to come up with this script which has worked well for me.
This script can be used directly on any SQL Server 2005/2008 database. It is database-specific, so it won't give output for all DB's on an instance, but I'm sure it could be modified to do so if necessary.
Hope you enjoy!
Steve
