Bug #48953 RFE: Config param to cause error on drop user under right conditions
Submitted: 20 Nov 2009 21:19 Modified: 21 Nov 2009 9:26
Reporter: Kevin Benton Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Security: Privileges Severity:S4 (Feature request)
Version:All OS:Any
Assigned to: CPU Architecture:Any

[20 Nov 2009 21:19] Kevin Benton
When dropping a user will cause problems, it would help me if MySQL would error out having determined that I will invalidate stored routines or views with sql security definer.

How to repeat:
See description

Suggested fix:
See description
[21 Nov 2009 9:26] Valeriy Kravchuk
Thank you for the feature request. 

As a workaround you can try to find out if any views or stored routines will be affected via corresponding tables in the INFORMATION_SCHEMA.