Chaining user host limit filter results into Access denied for user error

[sakkanan Packiaraj]

When views are created mysql by default adds DEFINER & SQL SECURITY context. For instance created view is like
------------------------------
CREATE
ALGORITHM = UNDEFINED
DEFINER = `user`@`%`
SQL SECURITY DEFINER
VIEW `somestat` AS
SELECT * FROM
`some_db`.`somestats`
-------------------------------
When host limit is added to user like "10.10.%,%" (for security reasons) getting "Access denied for user 'user'@'10.10.%.%' (using password: YES)" while doing "select" on the view

Looks like the DEFINER match is not working. The only workaround is to recreate the view, which is not practical (for us) as there are 100s of DB and each DB has 100s of views.

Is there any other way to add host restriction to user or any other workaround available

Also its not easy to correlate that adding host restriction on user needs views recreation

Appreciate your time and help.