Home » RDBMS Server » Enterprise Manager » What privileges are needed to run ASH-reports? (OEM 11g, RDBMS 10.2.0.3, HPUX)
What privileges are needed to run ASH-reports? [message #478722] Tue, 12 October 2010 04:10 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

What priviliges do a DB user need to run an ASH report? The user logs into OEM and then as a different user into the DB (I can run the ASH, but Im logged in as SYSTEM).

The user is getting ORA-00904: invalid identifier.

Regards
H

[Updated on: Tue, 12 October 2010 05:07]

Report message to a moderator

Re: What privileges are needed to run ASH-reports? [message #478727 is a reply to message #478722] Tue, 12 October 2010 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The one to execute the package DBMS_WORKLOAD_REPOSITORY.

Regards
Michel

[Updated on: Tue, 12 October 2010 07:33]

Report message to a moderator

Re: What privileges are needed to run ASH-reports? [message #478747 is a reply to message #478722] Tue, 12 October 2010 06:04 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
I found on metalink that adding the role oem_monitor will solve the issue. I will come back when I know if it did.
Re: What privileges are needed to run ASH-reports? [message #478764 is a reply to message #478747] Tue, 12 October 2010 07:33 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Indeed because OEM_MONITOR contains the EXECUTE privilege on the package.

Regards
Michel
Previous Topic: Kill Session
Next Topic: Need help with OEM
Goto Forum:
  


Current Time: Fri Mar 29 08:13:19 CDT 2024