-
Privileges
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
-
grant select on to ;
same as a table
-
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|