Bug #40777 Lost granted privileges after rebuilding function and procedures

• Submitted: 17 Nov 2008 9:45
• Modified: 21 Nov 2008 9:27
• Reporter: [e-mail] [e-mail]
• Status: Duplicate
• Category: MySQL Server: Security: Privileges
• Severity: S2 (Serious)
• Version: 5.0.67-community-nt
• OS: Any
• CPU Architecture: Any
• Tags: privileges function and procedures

[17 Nov 2008 9:45] [e-mail] [e-mail]

Description:
drop procedure if exists rs;
create procedure rs ...

After drop and create procedure or function Lost all earlier granted privileges for all users.

Please!

How to repeat:
grant execute on procedure rs to ulogin@hostname;
drop procedure if exists rs;
create procedure rs ...

[21 Nov 2008 9:27] Sveta Smirnova

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #31501