Displaying permissions and user names

To display the current permissions and mapped user names for both NT users and groups, use sp_logininfo. The following list describes this sample display:

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 the displayed users, groups, and permissions use the sp_grantlogin and sp_revokelogin procedures.