Viewing and Modifying Role Memberships

While using a database you may need to list the members of a database role or fixed server role. Additionally, when a Microsoft® SQL Server™ user no longer needs the permissions from a user-defined, fixed database or server role of which he or she is a member, you can remove the user from the role to keep the security system as simple as possible.

To view the members of a database role (fixed or user-defined)

         

To remove a user account from a database role (fixed or user-defined)

         

To view the members of a fixed server role

         

To remove a login from a fixed server role

         

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.