Deleting a Role

Use caution when deleting a role, because Database Control deletes a role even if that role is currently granted to one or more users. Before deleting a role, you may want to determine if the role has any grantees. Dropping (deleting) a role automatically removes the privileges associated with that role from all users that had been granted the role.

To determine if a role has any grantees: 

1. Go to the Roles page as described in "Viewing Roles".

2. In the Select column, click the desired role.

   If you do not see the desired role, then it may be on another page. In this case, do one of the following:

   • Just above the list of roles, click Next to view the next page. Continue clicking Next until you see the desired role.

   • Use the Search area of the page to search for the desired role. In the Object Name field, enter the first few letters of the role, and then click Go.

   You can then select the role.

3. In the Actions list, select Show Grantees, and then click Go.

   A report appears, listing the users that are granted the selected role.

4. Click Cancel to return to the Roles page.

To delete a role: 

1. If you are not there, then go to the Roles page, as described in "Viewing Roles".

2. In the Select column, click the desired role, and then click Delete.

   A confirmation page appears.

3. Click Yes.

   A confirmation message indicates that the role has been deleted successfully.