Sql_SysPermission.go 340 B

123456789101112
  1. package models
  2. var SqlUserPermission = `SELECT
  3. sys_permission.* ,
  4. FROM
  5. sys_user
  6. LEFT JOIN sys_user_role
  7. ON sys_user.id = sys_user_role.user_id
  8. LEFT JOIN sys_role_permission
  9. ON sys_role_permission.role_id = sys_user_role.role_id
  10. LEFT JOIN sys_permission
  11. ON sys_permission.id = sys_role_permission.permission_id`