I am working on an application that is hosted on same DB server as another application. We share this server with this another app, but we are under different schemas.
We have a need of RO access a table or materialized view or view under the schema of this another application. What would the best way to accomplish it and maintain in the long run:
a) Ask other application to allow RO access to their objects via a DB_link? May not be DB link since it allows a link between two different DBs and not the same.
b) Is there a better another way to handle this? How to write direct SQL queries against this other schema? We can provision a user ID to login to their schema and that user has RO to the objects we need?
Any ideas will be highly appreciated.
Thx
Al
We have a need of RO access a table or materialized view or view under the schema of this another application. What would the best way to accomplish it and maintain in the long run:
a) Ask other application to allow RO access to their objects via a DB_link? May not be DB link since it allows a link between two different DBs and not the same.
b) Is there a better another way to handle this? How to write direct SQL queries against this other schema? We can provision a user ID to login to their schema and that user has RO to the objects we need?
Any ideas will be highly appreciated.
Thx
Al