SQL> select user from dual;

USER                                                                            
------------------------------                                                  
USER1                                                                           

SQL> insert into teams
  2  values('besiktas',2);
insert into teams
            *
ERROR at line 1:
ORA-00942: table or view does not exist 


SQL>  insert into user15.teams
  2  values('besiktas',2);

1 row created.

SQL> commit;

Commit complete.

SQL> update user15.teams
  2  set name='besiktas'
  3  where name like 'r%';

2 rows updated.

SQL> commit;

Commit complete.

SQL> create synonym takim for user15.teams;
create synonym takim for user15.teams
*
ERROR at line 1:
ORA-01031: insufficient privileges 


SQL> create synonym takim for user15.teams;

Synonym created.

SQL> delete from takim
  2  where id<5;

4 rows deleted.

SQL> select * from takým;
select * from takým
              *
ERROR at line 1:
ORA-00942: table or view does not exist 


SQL> select * from takim;

NAME                    ID                                                      
--------------- ----------                                                      
Bursaspor                5                                                      
Dortmund                 8                                                      
GALATASARAY              5                                                      
Liverpool                7                                                      

SQL> commit;

Commit complete.

SQL>  select * from takim;

NAME                    ID                                                      
--------------- ----------                                                      
Bursaspor                5                                                      
Dortmund                 8                                                      
GALATASARAY              5                                                      
Liverpool                7                                                      

SQL> create synonym teams for user15.teams;

Synonym created.

SQL> insert into teams
  2  values('qqqq',2);

1 row created.

SQL> commit;

Commit complete.

SQL> insert into user15.teams
  2  values('rrrr',1);

1 row created.

SQL> commit;

Commit complete.

SQL> insert into user15.teams
  2  values('rrrr',1);
insert into user15.teams
                   *
ERROR at line 1:
ORA-00942: table or view does not exist 


SQL> --after the privelege is revoked we cannot use the table
SQL> --insert and update priveleges are granted agaiin
SQL> insert into teams
  2  values('fenerbahce', 2);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from teams;
select * from teams
              *
ERROR at line 1:
ORA-01031: insufficient privileges 


SQL> update teams
  2  set id=6
  3  where id<8;

8 rows updated.

SQL> commit;

Commit complete.

SQL> spool off