Skip to Main Content

Oracle Database Discussions

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!

Read only view using database link

939393May 11 2012 — edited May 11 2012
Hi All,


I want a user to access a database and run only select query over the same and nothing other operation he will perform. from one database to other.



Let say Database A is source and DB B is target

I want user X to access database B through Database A but user X only select the data from particular table not able to do any kind of modification.


I do like that :

create view readonly

1. Create read only views on the desired tables
2. Grant select access to another user.
3. create DBLINK for that user .


Am i write or wrong
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2012
Added on May 11 2012
2 comments
594 views