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

Oracle – Create monitor user script

Copy and Run the following script on your Oracle with sysdba permssions:

create user aimbetter IDENTIFIED BY aimbetterpw 
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 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;

Related Articles