CREATE USER user1
IDENTIFIED BY user1
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;

CREATE ROLE ReadOnly;
--GRANT SELECT ON table1 to ReadOnly;
--GRANT SELECT ON table2 to  ReadOnly;
--GRANT SELECT ON table3 to ReadOnly;
GRANT CONNECT to user1;
GRANT ReadOnly to user1;

grant create session to user1;

connect user1
show user