Problem with function in the where clause

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 Thu Jul 15 1999 - 23:57:42 CDT