ORACLE : HOWTO create user and something else

call imp system/%1@XE file=%2 log=import.log fromuser=USER touser=USER

call sqlplus USER/password@XE @scripts\update.sql

CREATE USER {user} IDENTIFIED BY "{password}" DEFAULT TABLESPACE "USER_DATA" TEMPORARY TABLESPACE "TEMP" QUOTA UNLIMITED ON "USER_DATA";

GRANT "CONNECT" TO {user} ;
GRANT "DBA" TO {user} ;
GRANT "RESOURCE" TO {user} ;

GRANT SELECT ON sys.v_$session TO {user};
GRANT CREATE TRIGGER TO {user};
GRANT CREATE TYPE TO {user};

of course change {user} & {password}