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?
Thanks in advance
GRANT SELECT ON SYS.V_$DATABASE TO MY_USER;
GRANT SELECT ON SYS.V_$INSTANCE TO MY_USER;
GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO MY_USER;
GRANT SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE TO MY_USER;
GRANT SELECT ON SYS.DBA_HIST_SNAPSHOT TO MY_USER;
GRANT ADVISOR TO MY_USER;