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:
- Create a new Enterprise Manager Role with performance monitor privileges for specific targets
- Create new Enterprise Manager Administrators and add them to the previously create role
- Create a new common user in the target databases for monitoring within the target databases
- Create a new Enterprise Manager Named Credential for these targets
So that’s a short list, now the (written) instructions per step: Continue reading