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

Performance Tuning

Another quick one as its one I just found and, as it turns out, is easy peasyÖ

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

User created.

SQL> grant connect, resource, advisor to awradm;

Grant succeeded.

SQL> grant select any dictionary to awradm;

Grant succeeded.

SQL> grant advisor to repview;

Grant succeeded.

SQL> grant execute on dbms_workload_repository to repview;

Grant succeeded.
Ö..And thats itÖthe awradm user can now run awrrpt.sql and addmrpt.sql