To display the current permissions and mapped user names for both Windows users and groups, use sp_logininfo.
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’
You do not need to add a login or grant further permissions to an Windows group, but you do need to add a login for each user in that group.
The first Windows user, named “chantal”, has the default parameter assigned as a permission. “chantal” is a member of the WEST domain, and her mapped Adaptive Server login name is “WEST_chantal”.
“WEST_chantal” is the name the System Administrator should use when assigning an Adaptive Server login name and permissions to this user.
The second Windows user, also named “chantal”, logs in from the EAST domain. Her mapped user name is simply “chantal”, since EAST has been set as Adaptive Server’s default domain (see the second item in this list).
To change or revoke users, groups, and permissions use the sp_grantlogin and sp_revokelogin procedures.