Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can access to OEM be restricted to the point where you can allow a non-admin user access to it but they can't modify any objects but can still view performance data, alerts, sessions, etc? I am a former DBA now developer and I don't have an environment where I can go verify this myself.

share|improve this question

You allow a non-admin user access to the Performance area of OEM by granting them the OEM_MONITOR role. However, be aware that this role does have a few additional priviliges that you may not want to provide. In that case I would create a similar role to OEM_MONITOR but with a reduced set of privileges.

share|improve this answer

Yes, just create the user with the PUBLIC role, then grant them VIEW ANY TARGET.

share|improve this answer
I'd have thought that for the tasks requested (view perf data etc) they'd also need appropriately privileged database users on the targets they have access to, strictly I suspect these wouldn't count as read-only users. – Niall Litchfield Nov 25 '11 at 8:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.