If I want the capability of generating AWR report, what privileges do I need?
I do not have access to grid control and enterprise manager. I want to run $ORACLE_HOME/rdbms/admin/awrrpt.sql and generate the (html) report.
I have SELECT_CATALOG_ROLE, bit that is not good enough. I need the capability to execute package DBMS_WORKLOAD_REPOSITORY. Is there a system privilege or role, which gives me this capacity?
If I am not an all powerful DBA, but a developer and need the capability of generating AWR report, what is the best way to achieve this?