Managing Roles

You can create, modify, and delete roles.

This section covers the following sections:

• Creating a Role

• Modifying a Role

• Deleting a Role

See Also Role Designer | Roles Node | Role Nodes

Creating a Role

To create a new role, select the Roles node in Server Explorer, then selectNew Role. The Role Designer appears.

See Also Role Designer

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 Role Designer

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 Role Designer