Hello Mina,

you can follow the below Steps:

Method :1

[code]

SQL> CREATE USER APPSREAD IDENTIFIED BY APPSREAD;
User created.

SQL> GRANT CONNECT, RESOURCE,CREATE SYNONYM TO APPSREAD;
Grant succeeded.
[/code]

Generate a Script for creating database objects of Application User ‘APPS’.

[code]
set echo off set
pagesize 0
set linesize 300
spool cr8synonyms.sql
select ‘create synonym ‘ || OBJECT_NAME || ‘ for ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘;’ from all_objects where OWNER in (‘APPS’) and
OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off

[/code]

Generate a script for selecting database objects of Application User ‘APPS’.

[code]
spool GrantSelect.sql
select ‘grant select on ‘|| OWNER ||’.’ ||OBJECT_NAME || ‘ to APPSREAD;’ from all_objects where OWNER not in (‘SYS’,’SYSTEM’) and OBJECT_NAME not like ‘%/%’ and OBJECT_TYPE in (‘TABLE’,’VIEW’,’SYNONYM’);
spool off

[/code]

Connect to sqlplus as sysdaba and execute the following script

[code]
SQL> @GrantSelect.sql
SQL> @cr8synonyms.sql
[/code]

Connect to Read only schema User and check the objects.

[code]
SQL> conn APPSREAD/APPSREAD Connected.
SQL> select count(*) from tab;
COUNT(*) ———- 15515
[/code]

Regards.

Hi , To compile the form manually, do the following.

frmcmp_batchmodule=/prod/apps/oraapp/apps_st/appl/au/12.0.0/forms/US/********.fmb userid=APPS/***** output_file=/prod/apps/oraapp/apps_st/appl/ap/12.0.0/forms/US/********.fmx module_type=form batch=yes compile_all=special

To compile the pl sql library

frmcmp_batch module=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.pll userid=APPS/****output_file=/prod/apps/oraapp/apps_st/appl/au/12.0.0/resource/********.plx module_type=library batch=yes compile_all=special

Mahmoud Morsy