Revoking Local Privilege Grants in Enterprise Manager

You can revoke local privileges in the PDB in which the privileges are used.

  1. From the Enterprise Manager database home page, log in to the PDB as a common or local user who has the CREATE USER and CREATE ROLE privileges.
  2. From the Administration menu, select Security, then Users.

    If prompted, enter your login information. Afterward, the Users page appears. In a PDB, both common and local users are listed.

  3. Select the user whose privileges you want to revoke and then click Edit.

    The Edit User page appears.

  4. Select Roles or the appropriate Privileges tab.

    Enterprise Manager displays a list of roles and privileges assigned to this user.

  5. Select Edit List and then remove the privileges as necessary.
  6. Click the OK button.