Tag Archives: EM

When you want a user, probably a developer, to have access via Enterprise Manager to show query performance, but *ONLY* to specific databases and it’s performance stats, you need a ‘restricted’ EM and database user to do this. Next is tested on EM 13.3 and an 18c container database.

Short list of things that need to be done:

1. Create a new Enterprise Manager Role with performance monitor privileges for specific targets
2. Create new Enterprise Manager Administrators and add them to the previously create role
3. Create a new common user in the target databases for monitoring within the target databases
4. Create a new Enterprise Manager Named Credential for these targets

So that’s a short list, now the (written) instructions per step: Continue reading →