You can see all roles granted to your login name or see the entire hierarchy tree of roles displayed in table format using sp_displayroles:
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 or the System Administrator can view information about roles granted to other users.
