Checking assigned roles of a SQL user...

This SQL command returns all of the roles that are assigned to the user selected at the end of the command. This is a good sanity check to ensure you have set the permissions you intended to.

SELECT r.name role_principal_name, m.name AS member_principal_name FROM
sys.database_role_members rm JOIN sys.database_principals r ON
rm.role_principal_id = r.principal_id JOIN sys.database_principals m ON
rm.member_principal_id = m.principal_id where m.name = '<username>' 

Note: Anything with in the <> greater/less than parentheses should be replaced with your filter parameter.