You can use sp_displayroles to see all roles granted to your login name or see the entire hierarchy tree of roles displayed in table format:
sp_displayroles {login_name | rolename [, expand_up | expand_down]}
Any user can execute sp_displayroles to see his or her own roles. Only the system security officer can view information about roles granted to other users.
