Read only database link in oracle database
Posted on 2012-03-27
I have one database say 'A' and there is a table called 'tb1' under a schema 'SC1'.
if there is another database called 'B' in another server and there is a schema 'SC2'. My requirement is to give the read-only access to the table 'tb1' in SC1 from the schema 'SC2' in database 'B'? can you please suggest how to make this work?