List all the groups and permissions assigned to a user in SQL Server.

ListRolesAndGroupsForUser.sql

select
      [principal_id]
    , [name]
    , [type_desc]
    , is_member(name) as [is_member]
from [sys].[server_principals]
where [type] in ('R','G')
order by [is_member] desc,[type],[name]