Bug #48950 RFE: UPDATE information_schema.routines SET definer = '...' WHERE ...
Submitted: 20 Nov 2009 17:47 Modified: 20 Dec 2009 18:18
Reporter: Kevin Benton Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Information schema Severity:S4 (Feature request)
Version:All OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2009 17:47] Kevin Benton 
Description:
When preparing to drop or change a user, it would be helpful if it were possible to change several stored procedure and function security types at once through the information schema.  This would make it possible to manage those privileges much more easily.

How to repeat:
See description

Suggested fix:
See description
[20 Nov 2009 18:18] Valeriy Kravchuk 
Why not to use mysql.proc table for similar update? See bug #48948.
[21 Dec 2009 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".