Subject | Re: Stored procedure loosing privileges |
---|---|
Author | hvlad |
Post date | 2010-08-13T06:38:59Z |
--- In firebird-support@yahoogroups.com, "Michael Horne" wrote:
Regards,
Vlad
>Looks like http://tracker.firebirdsql.org/browse/CORE-479
> 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??????/
Regards,
Vlad