Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I get a list of accessible tables

Re: How can I get a list of accessible tables

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 31 Jul 2003 15:31:49 GMT
Message-ID: <3F293665.21D34F96@remove_spam.peasland.com>


Try looking at ALL_TABLES.

HTH,
Brian

MCArch wrote:
>
> Is there any way for an Oracle 8i user to get a list of tables to which he
> has been granted Select? He doesn't own the tables and they don't list
> selecting from tabs.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Thu Jul 31 2003 - 10:31:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US