Oracle创建数据库同义词

1.在A用户下授权“商户信息表”给B用户

grant all on TBL_INF_MCHNT_INF to B;

commit;

2.在B用户下建立同义词

create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;

3. 查询数据库所有同义词select * from sys.synonyms