摘要:create synonym
--step 1:create synonym;
--create public synonym dept2 for dept; --不用加schme即可使用
--revode select on dept2 from hr;
--grant select on dept2 to ora1;
--列表
--select * from user_synonyms;
--使用schme_user_nm.xxx
select * from ht.DEPT2;