Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

OEM 13c Creating PDB level administrator account

Hi all,

OEM 13.4.0.0, Oracle DB 19.5, PCA 2.4.2

I received a request from customer offering DBaaS services to other departments.

Customer would like to create an OEM user with dba role but limited to the user's PDB only. Basically customer would like to give the tenant 100% control to the PDB administration, such as change user password profile, kill database sessions etc.

I've tried https://docs.oracle.com/en/enterprise-manager/cloud-control/enterprise-manager-cloud-control/13.4/emsec/pdb-administrator-access.html#GUID-CF21D7F8-2D83-4332-810D-B589EA25A240, doesn't allow me to view/change password profile.

I've also tried granting EM_ALL_ADMINISTRATOR role to the OEM user. This does the job, but it allows access to all PDB in the CDB, which is not allowed.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center