Bug or Feature?

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? Received on Thu Oct 14 1999 - 23:34:29 CDT