This is a follow-up to the earlier stored proc question. I have a stored proc, with user level permissions for execute. If I drop the stored proc and then create it again, the user level execute permissions go away. What is the proper way to edit/alter a store proc without losing these permissions?
Given this is the create syntax used: DELIMITER $$ CREATE [EMAIL PROTECTED] PROCEDURE sp_testlogin( P_user_name VARCHAR(32), P_password VARCHAR(32) ) SQL SECURITY DEFINER BEGIN SELECT * FROM users WHERE user_name = P_user_name ; END$$ DELIMITER ; I would think that I could use ALTER in this way: DELIMITER $$ ALTER PROCEDURE sp_testlogin( P_user_name VARCHAR(32), P_password VARCHAR(32) ) SQL SECURITY DEFINER BEGIN SELECT user_id, last_login FROM users WHERE user_name = P_user_name ; END$$ DELIMITER ; But I receive: ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( Can someone provide me an example of SP modification using alter (or whatever method works). Thanks, Gary -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
