Code: Select all
SELECT
g.name,
u.login,
FROM group_user gu
INNER JOIN users u on u.id = gu.user_id
INNER JOIN groups g on g.id = gu.group_id
ORDER BY g.name;
Reason why I use SQL is that I after setup of AD sync I am locked-out as root@localhost.