DROP USER <user_name> CASCADE;
CREATE USER <user_name> IDENTIFIED BY <password> DEFAULT TABLESPACE <tbsp_name>;
GRANT UNLIMITED TABLESPACE TO <user_name>;
GRANT DBA TO <user_name>;
GRANT CONNECT TO <user_name>;
GRANT RESOURCE TO <user_name>;
QUIT;