--------------------------------------------------------------------------------

i want to see the name & structure of all the tables of another user
provided the grant is given.

for example: i have got two user :NHPC4 and NHPCTEMP.
now when i logon to nhpc4 user,i want to see table name & structure of all the tables of nhpctemp.


should i write this:

select * from .tab where tname like 'ABC%'
which is not working.