These are the minimum grants needed to execute AWR reports.
GRANT SELECT ON SYS.V_$DATABASE TO awr_user; GRANT SELECT ON SYS.V_$INSTANCE TO awr_user; GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO awr_user; GRANT SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE TO awr_user; GRANT SELECT ON SYS.DBA_HIST_SNAPSHOT TO awr_user;