Hi all!

Working on Oracle v8i with OS as NT!

I have this problem while creating the following as under:

From Balaji login,I had granted the following privileges to user amitst as under:

SQL> grant select,insert,update,delete on tab to amitst;

Grant succeeded.

Say for instance,I from my login(amitst) would like to view all the tables of BALAJI as under:

SQL> conn amitst/amitst@biac
Connected.
SQL> select * from balaji.tab;
select * from balaji.tab
*
ERROR at line 1:
ORA-00942: table or view does not exist


SQL>

First of all,is the above procedure possible in Oracle!

Why is the above command not accepted successfully!

Could you please focus upon the area as to where I had gone wrong!

Thanks & Regards,

Amit.