5

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.

sukach
  • 183
  • 2
  • 7

2 Answers2

1

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.

John Doyle
  • 1,009
  • 1
  • 12
  • 19
0

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

Gaius
  • 11,238
  • 3
  • 32
  • 64