Re: Which table holds the view cols?

From: Praveen <p-nospam-mohanan_at_directvinternet.com>
Date: Fri, 15 Nov 2002 16:49:24 -0800
Message-ID: <3DD59614.6070001_at_directvinternet.com>

[Quoted] Hi..All,

    Its very difficult to find out from the all_tab_columns coz, if user A has a table tab1 & gives grant select to user B. Then if i create view tab1 in user B, & try to select from all_tab_columns it gives multiple rows .

Frank Diedrich wrote:
> "Praveen" <p-nospam-mohanan_at_directvinternet.com> schrieb im Newsbeitrag
> news:3DD53BD9.8090005_at_directvinternet.com...
>

>>Hi..All,
>>
>>     When a user creates a table, all_tab_columns/user_tab_columns

>
> holds the
>

>>list of columns. When we create view, the all_views table hold only

>
> the text of
>

>>the view when it was generated. Which table holds the name of the

>
> columns of the
>

>>view?
>>
>>TIA
>>
>>P/
>>

>
>
> Try also all_tab_colums and take view:name for table_name...
>
> Greetings,
>
> Frank
>
>
Received on Sat Nov 16 2002 - 01:49:24 CET