Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I want to restrict user to access only schema related to that user in BIP Model

Rajneesh S-OracleSep 8 2020 — edited Sep 11 2020

Hello All,

I created one SQL query based data model in BI publisher using one JDBC connection with a data base user , let's say XYZ.

I want to restrict user to access only schema related to that user, i.e. XYZ.

However it is able to access all other schema as per below screen shot:

pastedImage_0.png

Is there a way to restrict this user to access objects for other schema. In drop down list , all users/schema are getting listed and all db objects pertaining to those schema.

Thanks,

Rajneesh

This post has been answered by Rajneesh S-Oracle on Sep 11 2020
Jump to Answer
Comments