Creating a read-only APPS schema

To create a read-only APPS schema, use the following query.

CREATE USER "ROAPPS" PROFILE "DEFAULT" IDENTIFIED BY roapps
DEFAULT TABLESPACE "APPS_TS_TX_DATA"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK
GRANT SELECT ANY SEQUENCE TO "ROAPPS"
GRANT SELECT ANY TABLE TO "ROAPPS"
GRANT UNLIMITED TABLESPACE TO "ROAPPS"
GRANT "CONNECT" TO "ROAPPS"
GRANT "RESOURCE" TO "ROAPPS"
GRANT "SELECT_CATALOG_ROLE" TO "ROAPPS"
GRANT "CREATE SESSION" TO "ROAPPS"