Re: Why I don't use all_tab_columns

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

The ALL_ versions of the Oracle rdbms dictionary views are user rights dependent. You can see all the table_name you have select privilege on.

As a DBA privileged user the results should be the same queries against all_tables and dba_tables:

UT1> select count(*) from all_tables;

  COUNT(*)

      1856

UT1> select count(*) from dba_tables;

  COUNT(*)

      1856

HTH -- Mark D Powell -- Received on Thu Jan 09 2003 - 07:34:18 CST