On Oct 25, 9:56 am, epoko..._at_excite.com wrote:
> Just a guess:
>
> This could be due to privileges inherited from roles. If you don't
> grant
> privileges directly, stored procedures will not see referenced
> objects
> (roles are disabled for them unless they are authid current_user).
>
> Make sure the owner of the program unit has directly-assigned
> privileges (NOT via a role) on the synonym's target object.
Problem was resolved. You were close, I think it was something to do
with this as well as some sort of problem with some of the schemas
that some of the users were in. There was also an application config
problem that was certainly not making it easier to fix. I think in the
end the DBA recreated all the objects and I reconfigured the app. Now
things work. Not sure what the root cause was, but glad it's over.
Received on Fri Oct 26 2007 - 08:40:05 CDT
