Return to SP to List Role Permissions
Written by Brent Huscher on 14 September 2000
This script is updated from SQL Server 6.5. It will list all the GRANTed permissions in a database for a given role.