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: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 02 Dec 1999 09:50:42 -0500
Message-ID: <jo1d4s0nbstu6449fueikgla0fsqcmhsan@4ax.com>


A copy of this was sent to "Joe" <Dont_at_Send.Com> (if that email address didn't require changing) On Thu, 2 Dec 1999 14:14:43 -0000, you wrote:

>Hi Thomas
>Actually it's a bit more complex, I just now run a select on All_Views and..
>I notice that the View I created, as 'system' is owned by ORC, but I can't
>log in as ORC and I never connected as ORC as I don't have a password for
>ORC.
>So, what is going on?
>
>Thanks for your valuable time Thomas
>Joe
>

drop the view and then

can you post a cut and paste of system creating this view, trying to grant on it and the select from all_views showing the relevant information.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 02 1999 - 08:50:42 CST

Original text of this message

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