Search This Blog

Monday, July 10, 2017

Grants needed for AWR and ADDM reports on Oracle 11G

Following grants are necessary for a normal user to produce AWR and ADDM  reports.

For AWR
***********
GRANT SELECT ON SYS.V_$DATABASE TO  <username>;
GRANT SELECT ON SYS.V_$INSTANCE TO <username>;
GRANT EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY TO <username>;
GRANT SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE TO <username>;
GRANT SELECT ON SYS.DBA_HIST_SNAPSHOT TO <username>;

For ADDM
************
GRANT SELECT ANY DICTIONARY TO <username>;
GRANT ADVISOR TO <USERNAME>;

No comments:

Post a Comment