Another quick one as its one I just found and, as it turns out, is easy peasyÖ
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 repview;
Grant succeeded.
SQL> grant execute on dbms_workload_repository to repview;
Grant succeeded.
Ö..And thats itÖthe awradm user can now run awrrpt.sql and addmrpt.sql
