I have had the same problem with fb and interbase and the same situation. One stored procedure with the same name of another plus 2. In interbase everytime I backup and restore I have to grant again privileges.

Jesus Angel Garcia Zarco

El 12/08/2010, a las 20:18, "Michael Horne" <guardian_yahoo@...> escribió:

> Hello,
>
> Firebird version 2.1.3.18185 Firebird 2.1
>
> I have a stored procedure called SPWEB_VIEWPARTSCOSTWCF_FEEDER
> which was working great until yesterday I created a new stored
> procedure called SPWEB_VIEWPARTSCOSTWCF_FEEDER2. I before
> I got around to granting privileges for the new procedure because
> it was going to be a test procedure, our programs that used the
> original procedure started bombing with an error message
> of:
>
> >>This user does not have privilege to perform this operation
> >>on this object. No permission for execute access to
> >>PROCEDURE SPWEB_VIEWPARTSCOSTWCF_FEEDER.
>
> When I went and revoked and granted execution privilege on
> the original stored procedure all started working again.
>
> SPWEB_VIEWPARTSCOSTWCF_FEEDER 29 chars long
> SPWEB_VIEWPARTSCOSTWCF_FEEDER2 30 chars long
>
> With the max length set to 31 chars for a name, I
> don't understand what is happening.
>
> Could someone enlighten me??????/
>
> Thanks
> Michael
>
>

[Non-text portions of this message have been removed]