[Feature Request]: support grant role with view

[dengn]

Is there an existing issue for the same feature request?

• I have checked the existing issues.

Is your feature request related to a problem?

mysql> create view ci_store_id_1 as select * from ci_store where id = 1;
Query OK, 0 rows affected (0.36 sec)

mysql> create user store1 identified by 'Test@2025';
Query OK, 0 rows affected (0.31 sec)

mysql> create role store_manager;
Query OK, 0 rows affected (0.40 sec)

mysql> grant select on view ci_store_id_1 to store_manager;
ERROR 20101 (HY000): internal error: the object type "Unknown ObjectType" is unsupported

Describe the feature you'd like

Grant and Revoke should support view.

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

Additional information

No response