Re: Problem with function in the where clause

Have you tried to create a public synonym for the function and grant execute on this synonym to the other user. I think this should work.

On Thu, 15 Jul 1999 21:57:42 -0700, PMG <peteg_at_garlic.com> wrote:

>I have created a view which joins several tables, and the where clause
>includes something like ...and field1 = current_alignment...
>
>current_alignment is a function which returns an integer value.
>
>I am the owner of the tables and the function. The view works fine under
>my schema.
>
>I have granted select privileges to the underlying tables, and granted
>execute privilege to the function current_alignment.
>
>When I try to grant select privilege for the view to another user, I get
>ORA-03113!
>
>Interestingly, if I substitute the underlying query contained in the
>function as a subquery in the view script, I can execute the grant
>without any problem.
>
>Why can't one grant privileges on a view which uses a function in the
>where clause?
>
>TIA
>
>Pete
>
>
Received on Fri Jul 16 1999 - 03:27:10 CDT