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