Subject | Stored procedure loosing privileges |
---|---|
Author | Michael Horne |
Post date | 2010-08-12T18:18:36Z |
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:
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
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 operationWhen I went and revoked and granted execution privilege on
>>on this object. No permission for execute access to
>>PROCEDURE SPWEB_VIEWPARTSCOSTWCF_FEEDER.
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