Oracle Create synonyms

1: To SYSDBA login system, first create a user

Sql> Conn/assysdbaconnected.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

2: Switch to yshy user and create synonyms for scott.emp

Sql> Conn yshy/yshyconnected.sql for scott.emp; Synonym created.

3: query synonym, hint table or view does not exist.

Select * from y_emp; Select * from y_emp              *1: ORA-00942: Table or view does not Existsql

4: Login Scott authorizes the query authority of the EMP table to the Yshy user.

Sql> Conn scott/tigerconnected.sqlSelect on emp to yshy; Grant succeeded. SQL> Conn yshy/yshy; Connected.sqlSelect * from Y_emp;

"Delete Synonyms"
DROP [public] synonym [schema.] Sysnonym_name

Oracle Create synonyms