Hello Thomas, Ooopss, I was almost sure that it was "the history thing" ;-) Anyway- thank you very much for your interest and fixing the bug. Best regards,
Marcin Pytel -- Uzytkownik "Anhaus, Thomas" <[EMAIL PROTECTED]> napisal w wiadomosci news:[EMAIL PROTECTED] Marcin Pytel wrote : >Hello! >I think I have a kind of deja vu. >Coming back to the early version of SAP DB >(I think something about 7.3.0.18 or 7.3.0.20) >I remember reporting the bug about using sequences >in stored procedures. >Luckily this isn't very serious and the workaround isn't too much >complicated :-) >The problem is that a user who wants to use a stored procedure >which operates on counters (e.g. NEXTVAL) must have >explicit privileges to use that counters (granting a privilege >EXECUTE to this stored procedure isn't enough). >I remember that was fixed long, long ago, however, >few weeks ago I've migrated to the latest version of MaxDB >(7.5.0.26) and "guess who is here"? >Yes, it seems that somehow the old bug is reintroduced. >Steps to reproduce: >1. Create a user APP_ADMIN.(type - DBA) >2. Create a user APP_USER (type - STANDARD) >2. Log on using APP_ADMIN. >3. Create Sequence CNT_TEST. >4. Create Stored Procedure SP_TEST that is operating on CNT_TEST. >5. Grant an EXECUTE privilege to the user APP_USER for SP_TEST. >6. Log on using APP_USER. >7. Try to execute SP_TEST. >In my case, the error saying that "the counter CNT_TEST wasn't found" >is reported. >Could anyone confirm? >Thanks a lot for your support and patience ;-) > >Best regards, >Marcin Pytel > > >-- > Thanks for mailing the problem (again). Unfortunately I can't find any bug fix for the problem in any 7.3 release. My test with the newest 7.3 returns error -4020, unknown sequence name. This is also true for 7.5. 7.6 is the first release containing the bug fix. I will think about porting the fix back to 7.5. Best regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
