We help IT Professionals succeed at work.

Exactly what privilege I need to run AWR report and ADDM report in my schema?

sakthikumar
sakthikumar used Ask the Experts™
on
I am not a DBA, please tell me like, what privileges, I need,

To create AWR snapshots
To run / create AWR report
To run ADDM report
To run ASH report
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Below is the extract from one of the blogs...

http://orabackus.wordpress.com/2007/12/12/giving-access-to-run-awraddm-reports-to-a-non-priv-user/

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 awradm;

Grant succeeded.

SQL> grant execute on dbms_workload_repository to awradm;

Grant succeeded.

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

Commented:
grant select any dictionary to user;
grant advisor to user;
grant execute on dbms_workload_repository to user;
Expert Bajwa..

I believe that the synopsis which you had posted is already been suggested..!!