How to check user permissions on DB objects
How to check SQL server DB role membership
This is the TSQL to check the membership of a db role in MS SQL Server
Helpful programming code and scripts
This is the TSQL to check the membership of a db role in MS SQL Server