On the basis of the current system is in the past the old system, the database according to the business for the separation, separation into two Oracle instance, two part of the relationship between database tables exist before the Oracle, is now a DBLink to establish a link between synonyms, such previous system code to change the momentum is very small,

But there is a problem, the synonyms between two instances can be increased on the other side of the database table data deleted, and now I want to control, through a synonym for access only query, are not allowed to increase deleted, but did not find the corresponding information online, requests each great god help, data or sample code will do,

PS: two instances on a different server, a different username, then table Spaces and their user name, are given the DBA permissions

Thanked first!

CodePudding user response:

1, on the source server, set up a user permissions is low, named assume that L user
2, L fu B.T 1 query access to users, B is the source server business users;
3, L to create a synonym for S1, accessing B.T 1
4, the target server has business users to SS, creating the create database link XXX connect to L identified by pass using 'source IP/SID'
5, SS create a synonym for T1 for L.S 1 @ XXX