grant create synonym to SCOTT

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as SYSTEM@ORCL
 
SQL> grant create  synonym to SCOTT;
 
Grant succeeded
 
SQL> conn scott/tiger;
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 
Connected as SCOTT@ORCL
 
SQL> create  synonym dept_info for DEPT;
 
Synonym created
 
SQL> select * from dept;
 
DEPTNO DNAME          LOC
------ -------------- -------------
    50 公关部         台湾
    60 研发部         西安
    70 培训部         西安
    10 ACCOUNTING     NEW YORK
    20 RESEARCH       DALLAS
    30 SALES          CHICAGO
    40 OPERATIONS     BOSTON
 
7 rows selected
 
SQL> select * from dept_info;
 
DEPTNO DNAME          LOC
------ -------------- -------------
    50 公关部         台湾
    60 研发部         西安
    70 培训部         西安
    10 ACCOUNTING     NEW YORK
    20 RESEARCH       DALLAS
    30 SALES          CHICAGO
    40 OPERATIONS     BOSTON
 
7 rows selected
 
SQL> update dept_info set LOC='香港' where deptno=60;
 
1 row updated
 
SQL> select * from dept_info;
 
DEPTNO DNAME          LOC
------ -------------- -------------
    50 公关部         台湾
    60 研发部         香港
    70 培训部         西安
    10 ACCOUNTING     NEW YORK
    20 RESEARCH       DALLAS
    30 SALES          CHICAGO
    40 OPERATIONS     BOSTON
 
7 rows selected
 
SQL> select * from dept;
 
DEPTNO DNAME          LOC
------ -------------- -------------
    50 公关部         台湾
    60 研发部         香港
    70 培训部         西安
    10 ACCOUNTING     NEW YORK
    20 RESEARCH       DALLAS
    30 SALES          CHICAGO
    40 OPERATIONS     BOSTON
 
7 rows selected
 
SQL>