← Back to team overview

maria-discuss team mailing list archive

Re: Does user have SUPER privilege?

 

What about

SHOW GRANTS FOR  'user'@'host'
??

Refer https://dev.mysql.com/doc/refman/5.6/en/show-grants.html

On Wed, Apr 15, 2015 at 7:45 PM, Rasmus Johansson <rasmus@xxxxxxxxxxx>
wrote:

> Hi,
>
> I was wondering if there is a straight forward way to check whether a user
> has SUPER privileges or not.
>
> I came up with doing the following:
>
> --check for user’s Super_Priv on the current host
> SELECT Super_Priv FROM mysql.user WHERE user = 'user1' AND host = 'host1';
> --and then also check for user on whatever (%) host:
> SELECT Super_Priv FROM mysql.user WHERE user = 'user1' AND host = '%'
>
> But is there some more convenient way of doing it, maybe using SHOW GRANTS?
>
> Rasmus
>
> --
>
> Rasmus Johansson, VP Engineering
> MariaDB | t: +358 50 499 9589 | Skype: ratzpo
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>

References