First off I'm not a DBA and the company that I wrote a function and a view for has just recently lost their DBA and has not found a replacement for them yet. Here's my question.


I have a function in one schema that accesses a table and a view owned by another user in another schema. I'm getting an insufficient privileges error, at the view name in the function. I was getting it with the table too but I granted select to the user for all tables and that went away. What do I need to grant privileges for on the view?

Thanks for your time!
KMcKenzie