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 AnilPassi , He has eight plus year of Oracle Consulting experience & You can check some of his excellent work at http://oracle.anilpassi.com/
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 ....