We are moving Percona MySQL and trying to simulate roles in Percona Mysql. We are trying to create proxy user and simulate role. But its not working. Can some body suggest better way. We have around 50 odd roles and we need to simulate them. Other wise it would be difficualt to move to mysql from Oracle
Did you come across this blogpost https://www.percona.com/blog/2015/03/02/emulating-roles-percona-pam-plugin-proxy-users/ on Percona blog ? How are you setting it up and what version of MySQL you are using ?