How to Create Read Only Apps User:

-bash-3.2$ sqlplus / as sysdba

SQL> create user abc identified by abc DEFAULT TABLESPACE APPS_TS_TX_DATA TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON APPS_TS_TX_DATA;

User created.

SQL> grant connect to abc;

Grant succeeded.

SQL> spool abc_sesp.sql

SQL> set pagsize 10000;

SQL> set linesize 1000;

SQL> select 'grant select on '|| 'APPS.'||object_name ||' to '||'abc; 'from dba_objects where owner='APPS';

SQL> spool off;

Verify the abc_sesp.sql & if require edit (vi) the file change the changes

SQL> @ abc_sesp.sql

SQL> conn abc/abc

Connected.         

To verify all the connect responsibilities should be same as apps user: