Granting Access to run AWR/ADDM reports to a non priv user

In our environment many developers like/need(has knowledge) to look at the awr report to analyze and tune their problamatic queries and also understand the load details and wait events the database is facing. They request for privileges to run AWR/ADDM reports.

So see below simple steps we do to achieve this:

SQL>  create user awraddm identified by whatever 
2  default tablespace users
3  temporary tablespace temp;

User created.

SQL> grant connect, resource, advisor to awraddm;

Grant succeeded.

SQL> grant select any dictionary to awraddm;

Grant succeeded.

SQL> grant advisor to awraddm;

Grant succeeded.

SQL> grant execute on dbms_workload_repository to awraddm;

Grant succeeded.

…..And thats it…the awraddm user can now run awrrpt.sql and addmrpt.sql