Bug #22394 | Restore from Backup using MySQL Adm does not restore stored procedures correctly | ||
---|---|---|---|
Submitted: | 15 Sep 2006 15:13 | Modified: | 28 Sep 2006 17:41 |
Reporter: | Scott Hoellrich | Email Updates: | |
Status: | Won't fix | Impact on me: | |
Category: | MySQL Administrator | Severity: | S4 (Feature request) |
Version: | 1.2.3 rc | OS: | Windows (Windows 2003) |
Assigned to: | CPU Architecture: | Any | |
Tags: | 1.2.3 rc, 5.0.24, administrator, Backup, restore, server |
[15 Sep 2006 15:13]
Scott Hoellrich
[15 Sep 2006 15:26]
Scott Hoellrich
Updated OS and tags information for this ticket.
[18 Sep 2006 19:54]
Sveta Smirnova
Thank you for the reasonable feature request.
[27 Sep 2006 1:09]
Trudy Pelzer
I don't think this feature request should be implemented; changing the definer via a backup will create a security issue. The reason we store the definer in the first place is to record whose privileges may need to be checked when the routine executes. If there is a reason to change this, the correct procedure is to drop the routine and have the desired user recreate it. If we make the change, then it will be possible to circumvent correct privilege checking merely by dumping the database and restoring with a new definer -- not a safe thing.
[28 Sep 2006 17:41]
Trudy Pelzer
Per my earlier comment, we won't implement this functionality.