Re: Why I don't use all_tab

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 9 Jan 2003 05:15:15 -0800
Message-ID: <a20d28ee.0301090515.280a96d5@posting.google.com>

Markus Boehmer <markus.boehmer_at_schaefer-shop.de> wrote in message news:<avj95j$pne$1_at_news.dtag.de>...
> Here we go,
>
> I tried to use all_tab_columns but it hasn't worked.
>
> "SELECT DISTINCT OWNER FROM ALL_TAB_COLUMNS" returns only nine
> owners.
> If doing the same as dba I get 49 owners in return.
> Am I missing some rights?
>
> Any further suggestions are welcome.
>
> Greetings
> Markus

all_tab_columns will show you all the tables to which others have granted you access NOT all tables in the database. You should really read up on Oracle Concepts!

Hth

Sybrand Bakker
Senior Oracle DBA Received on Thu Jan 09 2003 - 07:15:15 CST

Re: Why I don't use all_tab_columns