Revoking Privileges

When you revoke privileges, all users in the group that you are revoking permission from are dropped from SQL Server databases, and their login IDs are removed from SQL Server.

    To revoke privileges

1. Choose the User Privilege or SP Privilege button. Or from the View menu, choose User Privilege or SP Privilege.

   The groups with that privilege are displayed.

2. Click the name of the group to revoke privilege from.
3. From the Security menu, choose Revoke.

   A confirmation message appears.

4. Choose Yes.

If you want to deny SQL Server access to a member of a group that has SQL Server privilege, use the Windows NT User Manager to remove the user from the group. The SQL Server login ID and any database usernames associated with that Windows NT account will remain in SQL Server but will be inaccessible to that user. You can periodically clean up these login IDs and usernames by using the Find Orphan SQL Login IDs option in the Search for Account Information dialog box.