Reviewing Account Details

You can get details about a group or about a user within the group. For an individual user, you can add a login ID that matches the user's mapped username, or you can drop a matching login ID if one already exists. You can also add or drop a user from a database or set the default database. For a group account, the same actions apply to all members of the group. For example, you can update login IDs for a group, which will add login IDs that match the mapped usernames of the group's members, if the login ID does not already exist.

    To review details about a user account
  1. Choose the User Privilege button. Or from the View menu, choose User Privilege.

  2. Double-click the group name that contains the user you want to get information about.

    The users within the group are displayed.

  3. Select the user, and then from the Security menu, choose Account Detail. Or double-click the username.

    The Account Detail dialog box appears. The Windows NT account name information for the user is displayed, as is the user's mapped username.

  4. Change any account information, as necessary.
  5. Choose the Close button.
    To review details about a group
  1. Choose the User Privilege button. Or from the View menu, choose User Privilege.

    The groups with user privilege are displayed.

  2. Select a group, and then from the Security menu, choose Account Detail. Or press the ctrl key and double-click the group name.

    The Account Detail dialog box appears. The Windows NT account information for the group is displayed, as well as the group's mapped SQL Server name.

  3. Change account information as necessary.
  4. Choose the Close button.