Stored Procedure Use vs. Role Use

[Quoted] I have a big problem. I have a major bit of PL/SQL, I want to put into a stored procedure. It works fine, without being in a stored procedure (just executing from SQL*PLUS command line). But when I put it into a stored procedure for actual use, it bombs. It has to do with grants on some of the tables I am accessing.

[Quoted] Evidently who ever executes the stored procedure, has to be granted access to the tables directly, not through roles. It's not the owner of the stored procedure, but the person executing it.

[Quoted] This will totally blow away our role/security structure and is not going to happen here.

Is there anyway around this, that anyone knows of? I can't believe something like this is causing such a problem. Roles are a great way to handle access, and for Oracle not to handle them properly, is a joke.

[Quoted] BTW... I will be calling the procedure from PowerBuilder, to an Oracle 7.3.3 database.

Thanks

-- 
**********************
Larry Jones
lljo_at_chevron.com