MySQL Forums
Forum List  »  MySQL Query Browser

MySQL similar approach as oracle and SQL server proxy user
Posted by: Syed Ali Raza
Date: January 09, 2018 03:50AM

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.

Options: ReplyQuote

Written By
MySQL similar approach as oracle and SQL server proxy user
January 09, 2018 03:50AM

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.