Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't Grant "select"

Re: Can't Grant "select"

From: Alan Shein <alanshein_at_erols.com>
Date: Thu, 2 Dec 1999 10:03:56 -0500
Message-ID: <8261oc$e39$1@autumn.news.rcn.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US