maria-discuss team mailing list archive

[Geoff Montee <geoff.montee@xxxxxxxxx>]

Hi Felipe,

On Wed, Apr 22, 2015 at 1:33 PM, Felipe Gasper <felipe@xxxxxxxxxxxxxxxx> wrote:
>
>         Is it possible to emulate user roles via PROXY in MariaDB?
>
>         Basically, I want to log in as “temp_w3gj6d6” but have the system
> treat that user as “frank”, including setting of DEFINERs and the like.
>
>         I see that there is a PAM plugin in MariaDB .. has anyone used that
> plugin to achieve this effect?
>

Coincidentally, I have a blog post scheduled to be published to
mariadb.com tomorrow that discusses how to use the PAM authentication
plugin to do exactly what you are asking.

Thanks,

Geoff