create_user.sql

 

---

 rem ======================================================================
 rem Name:  create_user.sql
 rem 
 rem 
 rem  Create the Lawson user.
 rem 
 rem  Run as the sys user!
 rem 
 rem ======================================================================
 
 grant connect, 
       resource, 
       select any sequence, 
       select any table, 
       execute any procedure, 
       analyze any, 
       audit any, 
       audit system to username identified by password;
 
 grant select, index, references on table to username;
 grant select on view  to username;
 grant execute on procedure to username;
 grant execute on function to username;
 grant execute on package to username;
 grant select on snapshot to username;
 
 alter user username
 default tablespace lawdata
 temporary tablespace lawtemp;

---