title: How can i create read only database link in oracle
body: <p>Consider the following scenerio....</p>
  
  <p>I have a master user MASTER.</p>
  
  <p>I have a test user TEST.</p>
  
  <p>For both users the table structure are same. Both user can be on different oracle servers.</p>
  
  <p>then I create a database link as master_link by logging in as test user to sql plus using the following command</p>
  
  <p><strong>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)))</strong></p>
  
  <p>By loggin in as test user and using the database link name i can modify the tables in master user. for example </p>
  
  <p><strong>update table1@master_link set display_title = 'PONDS' ;</strong></p>
  
  <p>This query updates the table table1 of master user.</p>
  
  <p>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.</p>