create user

CREATE USER username IDENTIFIED BY password
DEFAULT TABLESPACE tablespacename
TEMPORARY TABLESPACE tablespacename
PROFILE DEFAULT
ACCOUNT UNLOCK
/
GRANT "CONNECT" TO username
/
GRANT "RESOURCE" TO username
/
ALTER USER username DEFAULT ROLE "CONNECT",
"RESOURCE"
/
GRANT UNLIMITED TABLESPACE TO username
/