OraFAQ Forum: Enterprise Manager » What privileges are needed to run ASH-reports?

Home » RDBMS Server » Enterprise Manager » What privileges are needed to run ASH-reports? (OEM 11g, RDBMS 10.2.0.3, HPUX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

What privileges are needed to run ASH-reports? [message #478722]

Tue, 12 October 2010 04:10

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

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.

Report message to a moderator

Re: What privileges are needed to run ASH-reports? [message #478764 is a reply to message #478747]

Tue, 12 October 2010 07:33

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Indeed because OEM_MONITOR contains the EXECUTE privilege on the package.

Regards
Michel

Report message to a moderator

Previous Topic:	Kill Session
Next Topic:	Need help with OEM

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 19 03:15:44 CDT 2026