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@mariadb.com> 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp