1 Reply Latest reply: May 27, 2011 8:46 AM by orawiss RSS

    Privileges for generating AWR report

    rahulras
      Hi All,

      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
        • 1. Re: Privileges for generating AWR report
          orawiss
          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;