September 30, 2015
Oracle Database
How to generate AWR/ADDM report as normal database user ?
You can create a role awradmin and grant all necessary privileges to this role. Then you can grant any user awradmin role to generate AWR and ADDM report — First connect as sys user. SQL> CONN / as sysdba connected SQL>CREATE USER awrtest IDENTIFIED BY awrtest …