Display Permissions and User Names

To display the current permissions and mapped user names for both Windows users and groups, use sp_logininfo.

A sample listing of permissions and user names:
account name             mapped login name
          type                  privilege 
          -------------- ---------------------------------------------
BUILTIN\Administrators   BUILTIN\Administrators  
          group                 ‘sa_role sso_role oper_role’
WEST\chantal             WEST_chantal 
          user                  ‘default’
EAST\chantal             chantal 
          user                    ‘sa_role’

To change or revoke users, groups, and permissions use the sp_grantlogin and sp_revokelogin procedures.