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/

http://teachMeOracle.com/forum

Popularity: 15% [?]

Share This