How to remove a user account from a database role (Enterprise Manager)

How to Install SQL Server 2000

How To

How to remove a user account from a database role (Enterprise Manager)

To remove a user account from a database role

  1. Expand a server group, and then expand a server.

  2. Expand Databases, and then expand the database in which the role exists.

  3. Click Roles.

  4. In the details pane, right-click the role to which the user account belongs, and then click Properties.

  5. Select the user to remove, and then click Remove.

See Also

Viewing and Modifying Role Memberships