Skip Headers
Oracle® Database Security Guide
12c Release 1 (12.1)

E48135-09
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

7 Managing Security for a Multitenant Environment in Enterprise Manager

This chapter contains:

About Managing Security for a Multitenant Environment in Enterprise Manager

In a multitenant environment, you can use Oracle Enterprise Manager Cloud Control to create, manage, and monitor common users and roles for both the root and the associated pluggable databases (PDBs). Enterprise Manager enables you to switch easily between the root and a designated PDB.

Logging into a Multitenant Environment in Enterprise Manager

This section contains:

Logging into a CDB or a PDB

Different variations of the Enterprise Manager Database login page appear automatically based on the feature that you had requested while logging in. To log into a multitenant environment as a multitenant container database (CDB) administrator (an Enterprise Manager user who has the CONNECT privilege on the CDB target) to use a CDB-scoped feature, follow these steps:

  1. Log into Oracle Enterprise Manager Cloud Control as either user SYSTEM or SYSMAN.

    The URL is as follows:

    https://host:port/em

  2. Navigate to the Databases page.

  3. Select the database that you want to access.

    The database home page appears.

  4. Select the menu item for the action that you want to perform, such as selecting Administration, then Security, and then Users to authenticate a user.

    The Database Login page appears. The following example shows the Database Login page for the CDB (because the database name is shown as CDB$ROOT). Because of this name, this page is colloquially referred to as the database login page for the root of the multitenant environment. The Database field refers to the current database; had you selected a PDB, then the name of the PDB would appear in this field.

    Description of em_login.gif follows
    Description of the illustration em_login.gif

  5. Log in using the appropriate credentials.

    Remember that only common users can log into the root, and that the names of common users begin with C## or c##. Both common and local users can log into a PDB, depending on their privileges.

Switching to a Different PDB or to Root

  1. At the top left side of the page, find the database link.

    In the database link, the current container name appears. The following example shows that the current database is the CDB itself (CDB$ROOT), colloquially known as the root.

    Description of em_database_breadcrumb.gif follows
    Description of the illustration em_database_breadcrumb.gif

  2. Select the menu icon to the right of the container, and from this menu, select the database that you want to access.

    If the menu item does not appear, then navigate to a page where it does appear, such as the Database home page.

  3. When you decide which activity you want to perform (such as creating users), log in with the appropriate privileges.

    If you attempt to perform an activity without first having authenticated with the appropriate privileges, then you will be prompted to log in with the appropriate privilege.

Managing Common and Local Users in Enterprise Manager

This section contains:

Creating a Common User Account in Enterprise Manager

A common user is a user that exists in the root and can access PDBs in the CDB.

To create a common user:

  1. From the Enterprise Manager database home page, log into the root as a common user who has the common CREATE USER and SET CONTAINER privileges.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to a different PDB or to the root.

    See also "About Commonly and Locally Granted Privileges".

  2. From the Administration menu, select Security, then Users.

    If prompted, enter your login information. Afterward, the Users page appears.

  3. Click Create.

    The Create User page appears.

    Description of em_com_user_create2.gif follows
    Description of the illustration em_com_user_create2.gif

  4. Select the options to create a common user and grant this user privileges.

    Ensure that you preface the user name with C## or c##.

  5. Click OK or Apply.

    The common user is created in the root and will appear in the Users page for any associated PDBs.

Editing a Common User Account in Enterprise Manager

To edit a common user:

  1. From the Enterprise Manager database home page, log into the root or to the PDB.

    If you are logging into the root, then ensure that you are a common user who has the common CREATE USER and SET CONTAINER privileges. If you are logging into a PDB, ensure that you have the CREATE USER privilege for that PDB.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB.

  2. From the Administration menu, select Security, then Users.

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

  3. Select the common user to be edited and then click Edit.

    The Edit User page appears. For a common user in the root, you can modify all settings for the common user. For a common user in a PDB, you cannot change the user password, default tablespace, and temporary tablespace. The settings that you make apply only to the current PDB. The following screen shows how a common user Edit User page appears in a PDB.

    Description of em_com_user_edit.gif follows
    Description of the illustration em_com_user_edit.gif

  4. Modify the common user as necessary.

  5. Click Apply.

Dropping a Common User Account in Enterprise Manager

To drop a common user:

  1. From the Enterprise Manager database home page, log into the root as a common user who has the common CREATE USER and SET CONTAINER privileges.

    You cannot drop common users from PDBs.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB.

  2. From the Administration menu, select Security, then Users.

    If prompted, enter your login information. Afterward, the Users page appears, listing only common users.

  3. Select the common user that you want to drop and then click Delete.

  4. Confirm that you want to delete the common user.

Creating a Local User Account in Enterprise Manager

A local user is a user that exists only in a specific PDB and does not have access to any other PDBs in the multitenant environment.

To create a local user:

  1. From the Enterprise Manager database home page, log into the PDB as a local or common user who has the local CREATE USER privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Users.

    If prompted, enter your login information. Afterward, the Users page appears, showing only local users for the current PDB.

  3. Click Create.

    The Create User page appears.

  4. Select the options that create a local user and grant this user privileges.

    Ensure that you do not preface the user name with C## or c##.

  5. Click OK.

    The local user is created in the current PDB.

Editing a Local User Account in Enterprise Manager

To edit a local user:

  1. From the Enterprise Manager database home page, log into the PDB as a local or common user who has the local CREATE USER privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Users.

    If prompted, enter your login information. Afterward, the Users page appears, showing only local users for the current PDB and common users.

  3. Select the local user to be edited and then click Edit.

    The Edit User page appears.

  4. Modify the local user as necessary.

  5. Click Apply.

Dropping a Local User Account in Enterprise Manager

To drop a local user:

  1. From the Enterprise Manager database home page, log into the PDB as a local or common user who has the local CREATE USER privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Users.

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

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

    Enterprise Manager prompts you to confirm deletion of the user.

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

Managing Common and Local Roles and Privileges in Enterprise Manager

This section contains:

Creating a Common Role in Enterprise Manager

You can use a common role to assign a common set of privileges to common users. These roles are valid across all containers of the multitenant environment.

To create a common role:

  1. From the Enterprise Manager database home page, log into the root as a common user who has the common CREATE ROLE and SET CONTAINER privileges.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Roles.

    If prompted, enter your login information. Afterward, the Create Role page appears.

  3. Click Create.

    The Create Role page appears.

    Description of em_com_role_create.gif follows
    Description of the illustration em_com_role_create.gif

  4. Select the options that create a common role and grant this role privileges.

    Ensure that you preface the role name with C## or c##.

  5. Click OK.

    The common role is created in the root.

Editing a Common Role in Enterprise Manager

To edit a common role:

  1. From the Enterprise Manager database home page, log into the root or to the PDB.

    If you are logging into the root, then ensure that you are a common user who has the common CREATE ROLE and SET CONTAINER privileges. If you are logging into a PDB, ensure that you have the CREATE ROLE privilege for that PDB.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Roles.

    If prompted, enter your login information. Afterward, the Roles page appears. In the root, only common roles are shown. In the PDB, both common and local roles are shown.

  3. Select the common role to be edited and then click Edit.

    The Edit Role page appears. For a common user in the root, you can modify all settings for the common user.

    For a common role in a PDB, you can only change the role's authentication and grant this user different roles, system privileges, object privileges, and consumer group privileges. These settings apply only to the current PDB.

  4. Modify the common user as necessary.

  5. Click Apply.

Dropping a Common Role in Enterprise Manager

To drop a common role:

  1. From the Enterprise Manager database home page, log into the root as a common user who has the common CREATE ROLE and SET CONTAINER privileges.

    You cannot drop common roles from PDBs.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Roles.

    If prompted, enter your login information. Afterward, the Roles page appears, showing only common roles.

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

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

Revoking Common Privilege Grants in Enterprise Manager

To revoke common privilege grants:

  1. From the Enterprise Manager database home page, log into the root as a common user who has the common CREATE USER, CREATE ROLE, and SET CONTAINER privileges.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Users.

    The Users page lists the common users.

  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 roles or privileges as necessary.

  6. Click the OK button.

Creating a Local Role in Enterprise Manager

A common role can be used to assign a local set of privileges to local users later. These roles will be valid across PDB containers for whom they are defined.

To create a local role:

  1. From the Enterprise Manager database home page, log into the PDB as a user who has the local CREATE ROLE privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Roles.

    The Roles page appears.

  3. Click Create.

    If prompted, enter your login information. Afterward, the Create Role page appears.

  4. Select the options that create a local role and grant this role privileges.

    Ensure that you do not preface the role name with C## or c##.

  5. Click OK.

    The local role is created in the current PDB.

Editing a Local Role in Enterprise Manager

To edit a local role:

  1. From the Enterprise Manager database home page, log into the PDB as a user who has the local CREATE ROLE privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  2. From the Administration menu, select Security, then Roles.

    If prompted, enter your login information. Afterward, the Roles page appears, showing only local roles for the current PDB and common roles.

  3. Select the local role to be edited and then click Edit.

    The Edit User page appears.

  4. Modify the local user as necessary.

  5. Click Apply.

Dropping a Local Role in Enterprise Manager

To drop a common role:

  1. From the Enterprise Manager database home page, log into the PDB as a user who has the local CREATE ROLE privilege.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  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.

Revoking Local Privilege Grants in Enterprise Manager

To revoke local privilege grants:

  1. From the Enterprise Manager database home page, log into the PDB as a common or local user who has the CREATE USER and CREATE ROLE privileges.

    See "Logging into a Multitenant Environment in Enterprise Manager" for information about logging in and switching to the root or to another PDB

  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.