Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: no rows returned on execution
dmarsha3 wrote:
>
> group :
>
> I created a view as owner x which uses user_tab_columns as one of its
> tables. The works fine. But when I grant select on this view to user y
> it returns NO ROWS SELECTED. Looks like when the user y executes the
> oracle is using user_tab_columns of y instead of x. Is there any way
> to get around apart from using dba_tab_columns.
>
> Any help is appreciated.
>
> Thanks in advance.
>
> rama
> kramakri_at_dayton.csc.com
user_tab_columns is a view of the columns for the tables owned by the
current session user.
Received on Fri Nov 08 1996 - 00:00:00 CST