Erman Arslan's Oracle Forum › EBS 12.2

create user having readonly access to only apps schema

Classic

List

Threaded

2 messages Options

Roshan

create user having readonly access to only apps schema

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

Re: create user having readonly access to only apps schema

Administrator

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.