oracle建立同義詞

首先需要給使用者建立同義詞權限：

SQL> grant create synonym to jhchen;

Grant succeeded.

建立同義詞文法：

create synonym 名字 for 所有者.對象名

需要給用jhchen登陸

SQL>  create synonym eos_kpi_usersalary for kpi.eos_kpi_usersalary;

Synonym created

批量更改同義詞需要先在所有者那裡查詢：

SELECT ' create synonym ' || OBJECT_NAME || ' for kpi.' || OBJECT_NAME || ';'

  FROM USER_OBJECTS

 WHERE OBJECT_TYPE IN

       ('TABLE', 'VIEW', 'PROCEDURE', 'TRIGGER', 'FUNCTION', 'PACKAGE');

本文轉自 abc3486389 51CTO部落格，原文連結:http://blog.51cto.com/1336014/1655185