Hi,
Under APEX Oracle APEX 24.2.9 I would like to set rôles to users programmatically. When ROLE_IDS from the view APEX_APPL_ACL_USERS contains values, it is ther rôle. would like to select USER_NAME where they don't have any role affected. But when I do a select to return USERS with no roles, I don't get any results. This is the select :
select "ID","WORKSPACE_ID","WORKSPACE","WORKSPACE_DISPLAY_NAME","APPLICATION_ID","USER_NAME","ROLE_IDS","ROLE_NAMES" from "APEX_APPL_ACL_USERS" where "ROLE_IDS" IS NULL
What is the value of ROLE_IDS when no roles is affected to the user ? Is it different from null value?
Best regards.