Dropping a Local Role in Enterprise Manager

You can drop local role from the PDB in which the local role resides.

  1. From the Enterprise Manager database home page, log in to the PDB as a user who has the local CREATE ROLE privilege.
  2. From the Administration menu, select Security, then Role.

    If prompted, enter your login information. Afterward, the Roles page appears, showing only local roles for the current PDB and common roles. (You cannot drop common roles from a PDB.)

  3. Select the local role you want to drop and then click Delete.

    Enterprise Manager prompts you to confirm deletion of the role.

  4. Confirm that you want to delete the local role.