Monday, September 26, 2011

Privileges required for generating AWR reports


Some times you may have a requirment to generate AWR reports using non - administrator schemas.

The following privileges are required for a SCHEMA to generate AWR reports.

grant SELECT ON SYS.V_$DATABASE to SCHEMA;                     
SELECT ON SYS.V_$INSTANCE  to SCHEMA;
EXECUTE ON SYS.DBMS_WORKLOAD_REPOSITORY  to  SCHEMA;
SELECT ON SYS.DBA_HIST_DATABASE_INSTANCE  to SCHEMA;
SELECT ON SYS.DBA_HIST_SNAPSHOT  to SCHEMA;
GRANT ADVISOR  to SCHEMA;

0 comments:

Post a Comment

 

ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com