Apps Read only Schema in Oracle Applications

Often third party consulting/development of functional team need Apps Schema access to query underlying tables or database objects. Looking at importance and privileges of Apps Schema you as Oracle Apps DBA might not be interested in passing apps password to any one. You can create APPS read only schema so that users can query content but cannot edit or change anything.

For step by step process on How to create Read only Apps Schema Click here to check steps .
With this post I also want to introduce Anil Passi , He has eight plus year of Oracle Consulting experience & You can check some of his excellent work at http://oracle.anilpassi.com/

Share This Post with Your Friends over Social Media!

About the Author AppsDBA

Leave a Comment:

4 comments
ranjeeth says April 12, 2007

Hi Atul am a fresher in Apps.

HOW TO CONFIGURE THE ‘MODE OF CONNECTION’ IN BETWEEN CLIENT AND FORMS SERVER…. AS A SERVLET/SOCKET MODE…. AND HOW TO CHANGE FROM ONE TO ANOTHER…

I WILL BE VERY THANKFUL ….

Reply
Atul Kumar says April 12, 2007

Check

177610.1 Oracle Forms in Applications FAQ

201340.1 Using Forms Listener Servlet with Oracle Applications 11i

125767.1 Upgrading Developer 6i with Oracle Applications 11i

Reply
NeoHyd says January 18, 2008

As a general guideline Socket mode should be used for Intranet traffic and servlet for Internet. Socket mode is faster the servlet.

Reply
Narendra says June 30, 2011

Hi Atul,
Is it possible to alter fnd_user table present in fnd_user in apps schema.
Actually i am working on integration of OIM with EBS i need to provision users between oim to ebs. But in OIM design console i don’t find firstname and lastname fields so that i created manually and created a process task adapter for them.But firstname and lastname fields are not updated in the target system.

Thanks & Regards,
Narendra.Ch

Reply
Add Your Reply