Database roles simplify the process of managing privileges because you can grant privileges to a role, then grant the role to users. When you want to revoke privileges for a user, you can simply revoke role authorization from the user, rather than revoking each individual privilege.
You create and drop a role by using the same process that you would to make any database object change. For more information, see Managing database object changes by using the Properties view.
You can also view membership for a role in the Role Membership view. Right-click the role in the Object List or Data Source Explorer, and then click View Membership. If the View Membership menu is not available, this action is not available for your database server.