Use of "Grant Select" in SQL

[taqmeena]

I grant select for my own table to another user. But He can't open its data.SQL shows msg "Table no exist" . Is there any other way to Select statment for other owner's table. PLZ Help me ...................

 

[BJCooperIT]

The other user needs to append the schema name:

select * from tagmeena.tablename;

An alternative is for the other user to create a synonym for tagmeena.tablename and then select from the synonym.

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
Author and Sole Proprietor of: Emu Products Plus