How to remove a user account from a database role (Enterprise Manager)
To remove a user account from a database role
- Expand a server group, and then expand a server.
- Expand Databases, and then expand the database in which the role exists.
- Click Roles.
- In the details pane, right-click the role to which the user account belongs, and then click Properties.
- Select the user to remove, and then click Remove.