Home -> Usenet -> comp.databases.oracle -> How can a User see other tables ( when granted select priveleges ) ??

How can a User see other tables ( when granted select priveleges ) ??

From: Don <don_at_xxx.com>
Date: Mon, 23 Jul 2001 09:48:36 -0400
Message-ID: <h1aoltotbvdmpg6ogkmqjpn14ri33no822_at_4ax.com> 






User001 can always see his own tables 


   by select * from cat;



Output:

 User001.emp
 User001.dept
 User001.project






Let's say that User044


 gives select privilege on his table to User001.




How does User001 


make a select statement to see a list of tables that he is "allowed"
to see ?  ( Meaning his own tables and User044's tables )




desired output list:


 User001.emp
 User001.dept
 User001.project
 User044.inventory
 User044.salary
 User044.job


Received on Mon Jul 23 2001 - 15:48:36 CEST












Original text of this message