REM =======================================================
REM cleanup section
REM =======================================================

DROP USER adfdi CASCADE;

REM =======================================================
REM create user
REM three separate commands, so the create user command 
REM will succeed regardless of the existence of the 
REM DEMO and TEMP tablespaces 
REM =======================================================

CREATE USER adfdi IDENTIFIED BY adfdi;

ALTER USER adfdi DEFAULT TABLESPACE users
              QUOTA UNLIMITED ON users;

ALTER USER adfdi TEMPORARY TABLESPACE temp;

GRANT CREATE SESSION, CREATE VIEW, ALTER SESSION, CREATE SEQUENCE TO adfdi;
GRANT CREATE SYNONYM, CREATE DATABASE LINK, RESOURCE TO adfdi;