> Better add "SQL SECURITY DEFINER" to it. I noticed that it works with and without this. I have added it to the procedure.
Another quick question though. Since I have added the end user that will execute the procedure it works fine, until I drop the procedure and recreate it then I have to read the execute permission for that user. Is this normal behavior? I know that I should probably be using alter instead but I was just wondering. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]