Hello.
The problem may in that as of MySQL 5.0.3, it is necessary to have the EXECUTE privilege to be able to execute the routine. I think you should grant an EXECUTE privilege to other users. See: http://dev.mysql.com/doc/mysql/en/create-procedure.html http://dev.mysql.com/doc/mysql/en/stored-procedure-privileges.html >Greetings, > > I wanted to see if anyone else has found this problematic, or if > I just missed something. I upgraded from 5.0.2 to 5.0.3-beta on > my Red > Hat AS3 platform. It appears everything was fine till I went to > execute > my stored procedures, which were owned by root at the console, > since > that is the only local db access, all remote access is > controlled via > strong users/passwords. Running as the local db root account I > get > results I expect. I am getting no results back from any other id > attempting the SP execution from something like MySQL Query > Browser. > > I did notice two new items, a procs_priv table and that > you can > set DEFINER/INVOKER setting on the SP. However, none of > these have fixed > my problem. Also, I had to add the line manually to the > procs_priv table > to allow my user to execute the SP. [EMAIL PROTECTED] wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
