Create user in Oracle:

-- create the user with username//password
CREATE USER username IDENTIFIED BY password;

-- grant appropriate role to the user
GRANT CONNECT TO username;
GRANT RESOURCE TO username;