> 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]

Reply via email to