SQL> connect system/manager
SQL> Create user user50 identified by user50;
SQL> grant connect to user50;
SQL>grant select on icd.TRECORDINFO1 to user50;
CREATE SYNONYM sy_dept FOR scott.dept;
CREATE PUBLIC SYNONYM 同義詞 FOR 用戶名.對(duì)象名;
歡迎光臨 Chinaunix (http://www.72891.cn/) | Powered by Discuz! X3.2 |