REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	c_user_cr8.sql
REM
REM <SQLDIR_GRP>USER MAINT</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy (vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Creates database user for a Data Warehouse project
REM	can be used in batch mode:
REM		start c_user_cr8.sql 	username /
REM					password /
REM					tablespace /
REM					temp_tablespace /
REM					quota_in_MB
REM	</SQLDIR_TXT>
REM
REM Usage:
REM	c_user_cr8.sql
REM 
REM Example:
REM	c_user_cr8.sql
REM
REM
REM History:
REM	08-01-2001	VMOGILEV	Created
REM
REM


/*
========================
 1 = username
 2 = password
 3 = tablespace
 4 = temp_tablespace
 5 = quota_in_MB
========================
*/

set verify off



CREATE user &&1 identified by &&2 
DEFAULT TABLESPACE &&3
TEMPORARY TABLESPACE &&4 ;

GRANT connect, resource, CREATE DIMENSION, CREATE SNAPSHOT, CREATE TRIGGER, CREATE TABLE, QUERY REWRITE to &&1 ;

REVOKE unlimited tablespace from &&1 ;

ALTER USER &&1 quota &&5 ON &&3 ;


undefine 1
undefine 2
undefine 3
undefine 4
undefine 5