MySQL Forums
Forum List  »  MySQL Query Browser

impersonation in mysql
Posted by: Syed Ali Raza
Date: January 05, 2018 06:22PM

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.

Options: ReplyQuote

Written By
impersonation in mysql
January 05, 2018 06:22PM
January 05, 2018 07:18PM
January 08, 2018 06:37AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.