How to create a READ_ONLY User in Database | Oracle

1. connect with sqlplus with dba rights

sqlplus / as sysdba

2. create a simple user and give password:

create user test identified by test;

3. Give some grants to newly created user, like create session, and select

grant CREATE SESSION to test;
grant SELECT ANY TABLE to test;

:)