create_user.sql

rem ======================================================================
rem Name:  create_user.sql
rem Prog:  Jimmie Marks
rem Date:  December 27, 1995
rem   4. Create the Lawson user.
rem *NOTE* This script must be run as the sys user!
rem ======================================================================

grant connect, resource, select any sequence, select any table, execute any procedure, analyze any, audit any, audit system to reportsm identified by reportsm;

alter user reportsm
default tablespace lawdata
temporary tablespace lawtemp;