Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't Grant "select"
SELECT owner FROM dba_views WHERE view_name = 'VW_IN_CALL_DATA';
Joe <Dont_at_Send.Com> wrote in message news:yTu14.210$E36.10986_at_news2-hme0...
> Thanks Thomas
>
> I'll give it a try, but I wrote this View when loged in as 'whoever' and
I
> immedietly issued a Grant command but it wouldn't work.
>
> Is there a way of finding the 'owner' of this View?
>
> Thanks again
> Joe
>
> > No one can grant on anothers table without having first been granted
that
> > privelege with the GRANT OPTION.
> >
> > Eg: ORC must issue:
> > grant select on wv_in_call_data to SYS with grant option;
> > then, SYS can grant select on that table to others.
>
>
>
>
Received on Thu Dec 02 1999 - 09:03:56 CST
![]() |
![]() |