列出所有拥有DROP/DELETE权限的用户
答
select * from mysql.user where Delete_priv = 'Y' and Drop_priv = 'Y';
答
注意,该用户的权限可以在某些级别授予。
-- Global level privileges
SELECT CONCAT(user, '@', host) FROM mysql.user WHERE delete_priv = 'Y' OR drop_priv = 'Y'
-- Table level privileges
SELECT CONCAT(user, '@', host) FROM mysql.tables_priv WHERE FIND_IN_SET('delete', table_priv) <> 0 OR FIND_IN_SET('drop', table_priv) <> 0
还可以有数据库级别权限(请参阅mysql.db表)。