Consider the following scenerio....
I have a master user MASTER.
I have a test user TEST.
For both users the table structure are same. Both user can be on different oracle servers.
then I create a database link as master_link by logging in as test user to sql plus using the following command
CREATE DATABASE LINK master_link CONNECT TO MASTER IDENTIFIED BY password USING (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST =192.168.9.139)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = orcl)))
By loggin in as test user and using the database link name i can modify the tables in master user. for example
update table1@master_link set display_title = 'PONDS' ;
This query updates the table table1 of master user.
My requirement is i want to give read only permission to database link (master_link) so that test user can't modify or insert into any table in master user by using database link.