Hello.
Please, could you send the 'SHOW GRANTS' statement for the root and some other user (which should be able to execute the routine). Include the source of your function (use 'SHOW CREATE' statement) and definitions of the tables, if your routine works with them. What version of MySQL are you using? [EMAIL PROTECTED] wrote: > I have written a little routine that returns somebody's age from a > date-of-birth input, and it has always worked perfectly as part of a > client-side front end. > > However, the best place for it is as a server-side function, which MySQL v.5 > now allows. So I have re-written it as a server-side function and tried to > run it, but it only works so long as I log in as root. Any other user throws > up an error, regardless of permissions granted. And even logged in as root, I > cannot GRANT permission to EXECUTE for any other user. > > What's happening here??? > > Hugh de Saram > > -- 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]
