Hi
Apex 24.2
I am writing a new application.
The application currently has an authentication scheme Oracle APEX Accounts,
so this just looks at users set up via the workspace builder
I need to be able to add users via the application with assigned roles, so I have been looking at access control
I can create a new user in the workspace programatically using
BEGIN
APEX_UTIL.CREATE_USER(
p_user_name => :P2_USERNAME,
p_web_password => :P2_PASSWORD);
END;
I then tried to insert a row into APEX_APPL_ACL_USERS via SQL Workshop
insert into APEX_APPL_ACL_USERS (ID, WORKSPACE_ID, WORKSPACE, WORKSPACE_DISPLAY_NAME, APPLICATION_ID, APPLICATION_NAME, WORKING_COPY_NAME, USER_NAME,USER_NAME_LC)
values (
98284571177613283077,
23471099492326687943,
'GUS456',
'GUS456',
198800,
'PWA Projects',
null,
'NEWUSER1',
'NEWUSER1')
When I queried the table
select * from APEX_APPL_ACL_USERS
where application_id = 198800
I do not see the new row
If you create a user directly using access control, then there is no option for password
Am I completey misunderstanding something here
Regards
Gus