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
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