Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't Grant "select"
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
![]() |
![]() |