MySQL Bugs: #48953: RFE: Config param to cause error on drop user under right conditions

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:	None
Category:	MySQL Server: Security: Privileges	Severity:	S4 (Feature request)
Version:	All	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
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

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.