OEM access other people explain plan privilege?

From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Thu, 28 Jan 2010 11:34:11 -0800 (PST)
Message-ID: <679372.8393.qm_at_web65706.mail.ac4.yahoo.com>

I created a user on ORACLE 10GR2 and grant select_catalog_role and 'select any dictionary" provileges to this user.

This user will login to OEM Console (Client) and perform debug on all user's SQL statements.

The problem is this user can NOT access itself and other user's SQL statement and explain plan.

Any privilege I need grant to this user for him to access explain plan on OEM?


Received on Thu Jan 28 2010 - 13:34:11 CST

Original text of this message