相当于别名,比如把user1.table1在user2中建一个同义词table1
create synonym table1 for user1.table1;
这样当你在user2中查select * from table1时
就相当于查select * from user1.table1;
create synonym table1 for user1.table1;
这样当你在user2中查select * from table1时
就相当于查select * from user1.table1;