9 Managing Security for a Multitenant Environment in Enterprise Manager
You can manage common and local users and roles by using Oracle Enterprise Manager.
- About Managing Security for a Multitenant Environment in Enterprise Manager
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). - Logging into a Multitenant Environment in Enterprise Manager
You can log in to a CDB or a PDB, and switch from a PDB to a different PDB or to the root. - Managing Common and Local Users in Enterprise Manager
Oracle Enterprise Manager enables you to create, edit, and drop common and local users. - Managing Common and Local Roles and Privileges in Enterprise Manager
You can use Oracle Enterprise Manager to create, edit, drop, and revoke common and local roles.
Parent topic: Managing User Authentication and Authorization
9.1 About Managing Security for a Multitenant Environment in Enterprise Manager
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.
9.2 Logging into a Multitenant Environment in Enterprise Manager
You can log in to a CDB or a PDB, and switch from a PDB to a different PDB or to the root.
- Logging into a CDB or a PDB
Different variations of the Enterprise Manager Database login page appear automatically based on the feature that you requested while logging in. - Switching to a Different PDB or to the Root
From Oracle Enterprise Manager, you can switch from one PDB to a different PDB, or to the root.
9.2.1 Logging into a CDB or a PDB
Different variations of the Enterprise Manager Database login page appear automatically based on the feature that you requested while logging in.
To log in as a CDB administrator (an Enterprise Manager user who has the CONNECT
privilege on the CDB target) to use a CDB-scoped feature:
9.3 Managing Common and Local Users in Enterprise Manager
Oracle Enterprise Manager enables you to create, edit, and drop common and local users.
- 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. - Editing a Common User Account in Enterprise Manager
You can edit a common user account from the root. - Dropping a Common User Account in Enterprise Manager
You can drop a common user from the CDB root. - 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. - Editing a Local User Account in Enterprise Manager
You can edit a local user from the PDB in which the local user resides. - Dropping a Local User Account in Enterprise Manager
You can drop a local user from the PDB in which the local user resides.
9.3.1 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.
Related Topics
Parent topic: Managing Common and Local Users in Enterprise Manager
9.3.2 Editing a Common User Account in Enterprise Manager
You can edit a common user account from the root.
9.3.3 Dropping a Common User Account in Enterprise Manager
You can drop a common user from the CDB root.
Related Topics
Parent topic: Managing Common and Local Users in Enterprise Manager
9.3.4 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.
9.3.5 Editing a Local User Account in Enterprise Manager
You can edit a local user from the PDB in which the local user resides.
9.3.6 Dropping a Local User Account in Enterprise Manager
You can drop a local user from the PDB in which the local user resides.
Related Topics
Parent topic: Managing Common and Local Users in Enterprise Manager
9.4 Managing Common and Local Roles and Privileges in Enterprise Manager
You can use Oracle Enterprise Manager to create, edit, drop, and revoke common and local roles.
- Creating a Common Role in Enterprise Manager
Common roles can be used to assign common privileges to common users. - Editing a Common Role in Enterprise Manager
You can edit a common role from the root. - Dropping a Common Role in Enterprise Manager
You can drop a common role from the root. - Revoking Common Privilege Grants in Enterprise Manager
You can revoke common privilege grants from the root. - Creating a Local Role in Enterprise Manager
A common role can be used to assign a local set of privileges to local users later. - Editing a Local Role in Enterprise Manager
You can edit a local role in the PDB in which the local role resides. - Dropping a Local Role in Enterprise Manager
You can drop local role from the PDB in which the local role resides. - Revoking Local Privilege Grants in Enterprise Manager
You can revoke local privileges in the PDB in which the privileges are used.
9.4.1 Creating a Common Role in Enterprise Manager
Common roles can be used to assign common privileges to common users.
9.4.4 Revoking Common Privilege Grants in Enterprise Manager
You can revoke common privilege grants from the root.
9.4.5 Creating a Local Role in Enterprise Manager
A common role can be used to assign a local set of privileges to local users later.
9.4.6 Editing a Local Role in Enterprise Manager
You can edit a local role in the PDB in which the local role resides.
9.4.7 Dropping a Local Role in Enterprise Manager
You can drop local role from the PDB in which the local role resides.