/* $Id$ */
/*============================================================================*
 |                 Copyright (c) 2008 Applaud Solutions UK Ltd                |
 |                             All rights reserved                            |
 *===========================================================================*/

SET VERIFY OFF
SET FEEDBACK OFF
WHENEVER OSERROR  EXIT FAILURE ROLLBACK
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

CREATE USER &1 IDENTIFIED BY &2
               DEFAULT TABLESPACE APPS_TS_TX_DATA
               TEMPORARY TABLESPACE TEMP
               QUOTA UNLIMITED ON APPS_TS_TX_DATA;

ALTER USER &1 QUOTA UNLIMITED ON APPS_TS_TX_IDX;
GRANT CONNECT, RESOURCE TO &1;

COMMIT;
EXIT;
