impersonation in mysql

[Syed Ali Raza]

I need to implement impersonation in mysql

my requirement is to have 3 users say ali,irfan and a dummy.

ali and irfan user will have access to app.mytable but they should not be able to see the app.mytable unless they are connected with dummy user.

Note:- dummy user only have the permission to make connection but no right on mytable.

i.e as per oracle if ali is connected he will not see mytable but if he is connected as
ali[dummy] then he should be able to see the mytable.