Re: How can I get a list of accessible tables

Brian Peasland wrote:

> 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"

Doesn't answer the question. Tables can show up in ALL_TABLES if you are granted any privilege ... delete, insert, update, alter, reference, etc.: Not just SELECT. Any there are plenty of applications where you are allowed to insert but not select.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)