目前,我执行手动的两步过程来获取所有用户的授权信息。
步骤1:
SELECT user, host FROM mysql.user;
步骤2:
SHOW GRANTS FOR '«user»'@'«host»'; -- Repeated for all user-host pairs.
是否有一个单一的命令给我这个信息?
zdwk9cvp1#
您应该能够从information_schema中检索所有用户的权限:select grantee, group_concat(privilege_type) from information_schema.user_privileges group by grantee
select grantee, group_concat(privilege_type) from information_schema.user_privileges group by grantee
1条答案
按热度按时间zdwk9cvp1#
您应该能够从information_schema中检索所有用户的权限:
select grantee, group_concat(privilege_type) from information_schema.user_privileges group by grantee