create user having readonly access to only apps schema

[Roshan]

EBSR12.2.4
Oracle Linux 6.5
Oracle Database 11gR2

Hello,

do you know how I can create user having readonly access to only apps schema?

Thanks,
Regards

[ErmanArslansOracleBlog]

you will create a user and then give select grants to the tables of apps schema one by one. (dont give  select any table)
Use dynamic sql to build the grant statements.