MySQL similar approach as oracle and SQL server proxy user

[Syed Ali Raza]

In our web app , we have a single sign on scenario.

We have User1 and User2 have access to different tables in db. they log in using web credentials on our web app. we map them to a standard proxy db user (who itself does not have access on tables) and execute request as logged in user rights on db. this proxy user scheme is working for sql and oracle server. Pretty much standard proxy user support available in oracle and SqlServer. How we achieve similar in mysql?

MySQL proxy user help page , asks us to give grant rights to all tables to proxy /generic user and all logged in users use proxy/general user right to access data .
Where as we need proxy/generic user itselft not to have rights on db. rather to use rights of logged in user. this way user1 will only have access to its tables and not entire db.

Thanks in advance for any help.
Ali