create user &1
identified by &2
default tablespace &3
temporary tablespace temp;

grant dba to &1;

grant 	imp_full_database,
	exp_full_database,
	connect,
	resource,
	select any table,
	execute any procedure,
	create any view,
	create any table,
	create any index,
	drop any view,
	drop any table,
	drop any index to &1;

revoke unlimited tablespace from &1;
alter user &1 quota unlimited on &3;

CREATE OR REPLACE DIRECTORY dmpdir AS 'C:\ShareDir\iii\Backup';

GRANT READ,WRITE ON DIRECTORY dmpdir TO &1;

CREATE OR REPLACE DIRECTORY backup_dir AS 'C:\ShareDir\iii\Backup';

GRANT READ,WRITE ON DIRECTORY backup_dir TO &1;

GRANT READ,WRITE ON  directory backup_dir to public;
