Re: Forms 4.5 help

Cindy Swafford <Cindy_Swafford_at_pacibm.org> writes: > I have a form with a trigger that calls a stored procedure.
>
> When I am connected as the dba that created the stored procedure, I have
> no problems. When I am connected as a user with EXECUTE privileges on
> the procedure, I get a compilation error at run time:
>
> "procedure_name not declared in this scope"
>
> What do I have to do in order for my users to be able to run this
> procedure?
>
> I have done:
>
> "Grant execute on dba_name.procedure_name to user_name"

You have to create a synonym with the same name.

Sander Received on Wed Oct 22 1997 - 00:00:00 CEST