Subject Stored procedure loosing privileges
Author Michael Horne
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