同义词创建管理

CREATE SYNONYM XX_S_G7_GPS_POSITION FOR G7_GPS_POS@OTMIFDB;
SELECT * FROM XX_S_G7_GPS_POSITION;
SELECT * FROM USER_SYNONYMS;

（1）--授权某个用户crate synonym的权限，若用户名为scott
grant create synonym to scott
（2）--创建同义词
create [or replace] synonym syn_name from table_name;
（3）--撤销scott创建同义词的权限
revoke create synonym from scott;
（4）--删除同义词
Drop synonym syn_name