Which Roles Does The User Belong To?

SELECT r.[name] Role_Name FROM sys.database_principals u
JOIN sys.database_role_members rm ON u.principal_id = rm.member_principal_id
JOIN sys.database_principals r ON rm.role_principal_id = r.principal_id
WHERE u.[name] = USER_NAME()