Shulou(Shulou.com)06/01 Report--

First, you need to create synonym permissions for the user:

SQL > grant create synonym to jhchen

Grant succeeded.

Create synonym syntax:

Create synonym name for owner. Object name

Need to log in with jhchen

SQL > create synonym eos_kpi_usersalary for kpi.eos_kpi_usersalary

Synonym created

To change synonyms in bulk, you need to query the owner first:

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

FROM USER_OBJECTS

WHERE OBJECT_TYPE IN

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

Copy the following statement and execute it under the jhchen user!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.