Web lists-archives.org

Stored procedure permission error





Hi all,

I'm receiving an error when trying to invoke a procedure from a user@host which is not the definer. I created the procedure with the statement 'SQL SECURITY INVOKER' but is still not working. Does anyone know why? The MySQL version is 5.0.36.

Both users user@hosta and user@hostb have all privs on the database and also execute privs on the procedure.

Thanks in advance.

Regards,


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx