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

[20 Nov 2009 17:45] Kevin Benton
When preparing to drop 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:17] 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".