Nothing fancy but just a note on granting any database user privileges to run AWR reports.
As sysdba or system grant the following privileges to database user (say "scott")
Grant sys.advisor to scott;
grant execute on sys.dbms_workload_repository to scott;
Hope it helps!
As sysdba or system grant the following privileges to database user (say "scott")
Grant sys.advisor to scott;
grant execute on sys.dbms_workload_repository to scott;
Hope it helps!
No comments:
Post a Comment