1 Reply Latest reply on May 27, 2011 1:46 PM by orawiss

    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