MaxKB/apps/system_manage/sql/get_resource_user_permission_detail.sql

SELECT
    u.id,
    u.nick_name,
    u.username,
    case
		when
	      wurp."permission" is null then 'NOT_AUTH'
		else wurp."permission"
	end
FROM
    public."user" u
LEFT JOIN (
    SELECT
        user_id ,
	(case
		when  auth_type = 'ROLE'
		and  'ROLE' = any( permission_list) then 'ROLE'
			when  auth_type = 'RESOURCE_PERMISSION_GROUP'
			and 'MANAGE'= any(permission_list)   then 'MANAGE'
			  when  auth_type = 'RESOURCE_PERMISSION_GROUP'
			and 'VIEW' = any( permission_list) then 'VIEW'
			else null
		end) as "permission"
    FROM
        workspace_user_resource_permission
        ${workspace_user_resource_permission_query_set}
        ) wurp
ON
    u.id = wurp.user_id
${user_query_set}