Friday, May 17, 2013

Diagnostic Page and Personalization Pages are opening without asking for passwor

Solution:

This is a intended behavior in R12 release, to control the access to the diagnostic page we need to change the profile value below.

Step1; Login to applications with sysadmin user.
Step2: Select system administrator responsibility from the list
Step3: Navigate to profile
Step4: Select for system option
Step5: Search for Utilities%
Step6: Change the profile Utilities: Diagnostic to "No"
Step7: Bounce middle tier services.
Step8: Retest the issue.

Thursday, May 16, 2013

Creating APPS READ ONLY schema in Oracle Applications

Step1:

bash $ sqlplus "/ as sysdba"

SQL > create user appsro identified by appsro default tablespace APPS_TS_TX_DATA;

SQL> grant connect, resource to appsro;

SQL> grant create synonym to appsro;

SQL> exit;
Step2:bash $ sqlplus apps/******
SQL>set head off

SQL> set newpage none

SQL> set pagesize 9999

SQL> spool create_synonyms.sql

SQL> select 'create synonym ' || OBJECT_NAME || ' for ' || OWNER ||'.' ||OBJECT_NAME || ';' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

SQL> spool off

SQL> spool grant_select.sql

SQL> select 'grant select on '|| OWNER ||'.' ||OBJECT_NAME || ' to appsro;' from all_objects where OWNER not in ('SYS','SYSTEM') and OBJECT_NAME not like '%/%' and OBJECT_TYPE in ('TABLE','VIEW','SYNONYM');

SQL> spool off

SQL> exit;
bash $ sqlplus "/as sysdba"

SQL> @grant_select.sql

SQL> exit;
bash $ sqlplus appsro/appsro

SQL> @create_synonyms.sql

SQL> exit;
Verify the newly created user with apps user:  SQL> show user
USER is "APPS" SQL> SQL> select count(*) from apps.fnd_user; COUNT(*) ---------- 164 SQL> select count(*) from apps.fnd_concurrent_requests; COUNT(*) ---------- 12737 SQL> conn "CONFSOFT"/apps_readonly Connected. SQL> SQL> SQL> show user USER is "CONFSOFT" SQL> select count(*) from apps.fnd_user; COUNT(*) ---------- 164 SQL> select count(*) from apps.fnd_concurrent_requests; COUNT(*) ---------- 12737 SQL>