Oracle 创建同义词

SQL> conn /as sysdba
Connected.
SQL> create user yshy identified by yshy;

User created.

SQL> grant connect to yshy;

Grant succeeded.

SQL> grant resource to yshy;

Grant succeeded.

SQL> grant create synonym to yshy;

Grant succeeded.

SQL> 

SQL> conn yshy/yshy
Connected.

SQL> create synonym y_emp for scott.emp;

Synonym created.

SQL> select * from y_emp;
select * from y_emp
              *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> 

SQL> conn scott/tiger
Connected.
SQL> grant select on emp to yshy;

Grant succeeded.

SQL> conn yshy/yshy;
Connected.
SQL> select * from y_emp;