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 用户名.对象名;
2153阅读 0评论2011-01-11 wuhen33400
分类:Oracle
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 用户名.对象名;