Re: Allow a developer to view AWR reports on dbconsole

NetComrade wrote:
> Which privilage should be given?
>
> Tried select_catalog_role, and select dictionary, but it seems like it
> wants more.
>
> Thanks.
> .......
> We run Oracle 9iR2,10gR1/2 on RH4/RH3
> remove NSPAM to email

In $ORACLE_HOME/rdbms/admin, look for a script called awrrpt.sql to see the "tables" that AWR uses. You'll see that this script calls another script, awrrpti.sql, which in turns calls other scripts. But by going through these scripts, you'll see the objects that AWR accesses.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown