Privileges required for generating AWR reports

Some times you may have a requirment to generate AWR reports using non - administrator schemas.

The following privileges are required for a SCHEMA to generate AWR reports.

grant SELECT ON SYS.V_$DATABASE to SCHEMA;                      SELECT ON SYS.V_$INSTANCE  to SCHEMA; EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY  to  SCHEMA; SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE  to SCHEMA; SELECT ON SYS.DBA_HIST_SNAPSHOT  to SCHEMA; GRANT ADVISOR  to SCHEMA;