Re: Apps read only access

Posted by ErmanArslansOracleBlog on Mar 12, 2020; 11:32am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Apps-read-only-access-tp8145p8146.html

You can easily do this  by connecting your database and checking the APPS grants.
After getting the apps user grants, filter them and gather a list of read only grants.
Once you gather the read only grants, just create a db user such as APPSRO and grant those grants to it.

That's what you need to do. You can do this by using dynamic sql as well..

There are lots of publically available blog posts about this subject. You can check them if you don't know how to gather and filter APPS user grants.