How to grant the select privilege ?

[bang_dba]

Originally posted by Thomasps

SQL> create synonym  xx for th.ddf;

Synonym created.

SQL> select * from xx;
select * from xx
              *
ERROR at line 1:
ORA-00980: synonym translation is no longer valid

Abhay is correct.

I Dont had any user by name BALKE....

You get "ORA-00942: table or view does not exist"
when u create a PUBLIC synonym

create public synonym xxx for th.ddf

SELECT * FROM XXX

ORA-00942: table or view does not exist