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.