Re: Bug or Feature?

A copy of this was sent to PMG <peteg_at_garlic.com> (if that email address didn't require changing) On Thu, 14 Oct 1999 21:34:29 -0700, you wrote:

>I tried to grant select rights to Jones for a view that I created but
>SQL+ craps out with err msg ORA-03113: end-of-file on communication
>channel.
>
>The view uses a stored function in the where clause. (The function
>returns an integer). I had already granted execute privileges to Jones
>for the function so that's not the problem.
>
>Why can't you grant select rights for a view that uses a function in its
>where clause?
>
>P.S. Interestingly enough, the following work-around was successful:
>1. create the view but instead of using the function in the where
>clause, use the equivalent SQL
>2. grant privileges on the view to another user
>3. replace the SQL in the where clause with the function
>
>So, is this a bug or what?
>
>

yes it is a bug - it was in 7.3 i believe and fixed. Your workaround above is the workaround suggested in the bug.

--
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 Fri Oct 15 1999 - 07:36:08 CDT