Read only view using database link
939393May 11 2012 — edited May 11 2012Hi 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