ORCL@TAJ>conn taj/taj
Connected.
ORCL@TAJ>create table ttt ( no number);

Table created.

ORCL@TAJ>insert into ttt values (1);

1 row created.

ORCL@TAJ>commit;

Commit complete.

ORCL@TAJ>create role select_role;

Role created.

ORCL@TAJ>grant select on ttt to select_role;

Grant succeeded.

ORCL@TAJ>grant select_role to scott;

Grant succeeded.

ORCL@TAJ>conn scott/tiger
Connected.
ORCL@TAJ>create synonym tt for taj.ttt;

Synonym created.

ORCL@TAJ>desc tt
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 NO                                                 NUMBER

ORCL@TAJ>select * from tt;

        NO
----------
         1

ORCL@TAJ>