How to Create and Manage Enterprise Manager Database Express Users in Oracle 12c - dummies

How to Create and Manage Enterprise Manager Database Express Users in Oracle 12c

By Chris Ruel, Michael Wessler

In Oracle 12c’s Enterprise Manager (EM) Database Express, all users with the Database Administrator (DBA) or EM_EXPRESS_ALL roles are super users. This means that they can do almost anything in the tool including causing damage to the database. Therefore, be very careful to whom you grant these roles and allow to access EM Database Express.

  1. Choose Security from the menu bar at the top of any page within Enterprise Manager.

  2. From the drop-down menu, choose Users.

    Here is the Users configuration page. You can see a Create User button on top of that list.

    image0.jpg

  3. Click the Create User button.

    The Create User dialog box opens.

  4. Fill in these fields:

    • Name

    • Password

    • Confirm Password

    Leave everything else as default.

  5. Click the Next arrow.

  6. Leave the DEFAULT and TEMPORARY tablespaces with the default values.

  7. Click the Next arrow to complete your selection of privileges.

  8. Choose the EM_EXPRESS_ALL role and move it to the right by clicking the right arrow. Then click OK.

    The user is created.

Removing users is simple. On the Security page, click the user you want to remove, click Actions in the upper-left corner of the Security page, and choose Drop User from the drop-down list. Click OK when you’re satisfied with your choice.

By clicking the Show SQL button in the Create User dialog box, you can see the SQL that was generated by EM Database Express to create the user.

image1.jpg

When you remove a user via the Security page, the user is also removed from the database. So, if the user created any objects outside of EM Database Express, those objects are removed as well.