create user <username> IDENTIFIED by <password> ; grant create session, resource, CREATE VIEW to <user name>; code example
Example: oracle sql create user
CREATE USER MY_USER IDENTIFIED BY "MyPassword"
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO MY_USER;
GRANT RESOURCE TO MY_USER;
GRANT MY_ROLE TO MY_USER;
ALTER USER MY_USER DEFAULT ROLE "RESOURCE","CONNECT","MY_ROLE";
ALTER USER MY_USER GRANT CONNECT THROUGH MY_OTHER_USER;
SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = MY_USER;