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

revoke unlimited tablespace from &1;

alter user &1 quota unlimited on &3;
alter user &1 quota unlimited on temp;
alter user &1 temporary tablespace temp quota unlimited on &1

GRANT ALTER SESSION TO &1;
GRANT CREATE DATABASE LINK TO &1;
GRANT CREATE PROCEDURE TO &1;
GRANT CREATE SEQUENCE TO &1;
GRANT CREATE SESSION  TO &1;
GRANT CREATE SYNONYM TO &1;
GRANT CREATE TABLE TO &1;
GRANT CREATE TRIGGER TO &1;
GRANT CREATE TYPE TO &1;
GRANT CREATE VIEW TO &1;
GRANT CREATE JOB TO &1;


GRANT CREATE ANY SYNONYM TO &1;
GRANT DROP ANY SYNONYM TO &1;
GRANT SELECT ANY TABLE TO &1;
