OEM access other people explain plan privilege?

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 28 Jan 2010 11:34:11 -0800 (PST)

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?

ThaKs.


      

--
//www.freelists.org/webpage/oracle-l


Other related posts:

  • » OEM access other people explain plan privilege? - dba1 mcc