Transact SQL scripts written by
DBAs and Developers for
DBAs and Developers.
To submit a comment about this script
here or to submit your own script
Generate Database Role Permissions
This script will generate a list of all users and their corresponding database role(s). As an added bonus it provides a T-SQL Script that can be executed on the database. This can be useful when you want to replicate permissions from one server to another for a given database.