Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Code Block
SELECT user.user.account AS user_name, user.role_binding.uid AS user_id, user.role.name AS role_name, user.role.id AS role_id
FROM user.user
JOIN user.role_binding ON user.user.uid = user.role_binding.uid
JOIN user.role ON user.role_binding.role_id = user.role.id
WHERE user.user.account = "admin";