

REM Generated ANT SQL Runner Stub
REM You can delete this file

-- Script to create Fusion Order Demo schema owner
-- Note that the actual schema owner is passed in as a parameter
-- to allow for multiple instances on a shared sever

-- $Id: createFODSchema.sql 2242 2007-08-28 01:23:48Z lmunsing $

DROP USER FODtest CASCADE;

CREATE USER FODtest IDENTIFIED BY fusion DEFAULT TABLESPACE users 
                                  TEMPORARY TABLESPACE temp  
                                  QUOTA UNLIMITED ON users;

GRANT create session TO FODtest ;
GRANT alter session TO FODtest ;
GRANT create table TO FODtest ;
GRANT create trigger TO FODtest ;
GRANT create view TO FODtest ;
GRANT create sequence TO FODtest ;
GRANT create synonym TO FODtest ;
GRANT create type TO FODtest ;
GRANT create procedure TO FODtest ;

