Re: HELP - PL/SQL using DBMS_SQL in Store Procedures doesn't work!

madhus_at_aquas.com wrote:
>
> My guess is that the tables: w_wellwork_common, w_selected_wellwork
> are not
> owned by the user under which you are logging in and executing. If
> this is
> the case, give select access on these tables directly to the user, not
> thru'
> a role. Procedures require direct access. Try this and it should work.
> good luck!
>

When executing a stored procedures, the access rights in effect are those of the owner of the SP. So the access should be given directly to the owner of the SP, not the user.

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"