1. Home
  2. Settings
  3. Oracle Settings
  4. Oracle – Create monitor user script

Oracle – Create monitor user script

Notice:

1- Copy the relevant script according to your installation type:
On-Premise or on Amazon RDS


2- The created user name must be “aimbetter”. Any other user, even with administrator credentials, won’t be able to collect the information from the monitored Oracle server.


3- The user that runs the scripts to create the aimbetter user must have sysdba privileges.

4- Substitute aimbetterpw in the scripts with your choice of password.

5- The scripts consider the default Oracle users tablespace named users. If your Oracle database has another name for this tablespace, substitute users in the scripts with the correct tablespace name.

6- The script should be run in the Oracle database instance to be monitored. Check how to establish a connection to the Oracle Database on Windows.

On-Premise Oracle – Create Monitor User Script

create user aimbetter IDENTIFIED BY aimbetterpw; /*substitute aimbetterpw with your password*/ 

grant connect, select any dictionary to aimbetter;
grant create table 	to aimbetter;  
grant create procedure  to aimbetter;  
grant execute on dbms_lock to aimbetter;

grant create any directory to aimbetter;
grant create type to aimbetter;
grant create procedure to aimbetter;
grant execute on utl_file to aimbetter;

alter user aimbetter quota 10G on users; 

REM Grant Create Job to aimbetter;

Amazon RDS Oracle – Create Monitor User Script

create user aimbetter IDENTIFIED BY aimbetterpw /*substitute aimbetterpw with your password*/ 
default tablespace users
temporary tablespace TEMP;

grant connect, select any dictionary to aimbetter;
grant create table 	to aimbetter;  
grant create procedure  to aimbetter;  
grant execute on dbms_lock to aimbetter;

grant execute on rdsadmin.rdsadmin_util to aimbetter;
grant create type to aimbetter;
grant create procedure to aimbetter;
grant execute on utl_file to aimbetter;

alter user aimbetter quota 10G on users; 

REM Grant Create Job to aimbetter;