Managing Roles
You can create, modify, and delete roles.
This section covers the following sections:
See Also
Creating a Role
To create a new role, select the Roles node in Server Explorer, then select New Role. The Role Designer appears.
See Also
Modifying a Role
To modify a role, select the Roles node in Server Explorer. Select the role to modify, right-click, and select Edit. The Role Designer appears.
Note:
The role name cannot be modified.
See Also
Deleting a Role
To delete a role, select the Roles node in Server Explorer. Select the role to delete, right-click, and select Delete. When the confirmation message appears, select Yes.
Note:
Only a user that has been granted the DROP ANY ROLE system privilege or has been granted the role with ADMIN OPTION can drop other roles.
See Also