Privileges

[KMcKenzie]

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

[davey23uk]

grant select on <view_name> to <user>;

same as a table

[slimdave]

edit: never mind

[KMcKenzie]

OK has to be the specific name there isn't any grant select onto all views.

Thanks for taking the time to help me out.