Hello
I'm using Apex 24.1 and I want to deploy a self password request in the login in screen.
I've created a button that validate that the user is registered and has a valid email address, create a new valid password, and send to the user through email, but when I try to use the APEX_UTIL.RESET_PASSWORD to set the new password I've found that it can only be invoked by a user with the APEX_ADMINISTRATOR_ROLE if the old password is not provided.
I wonder if there is a way to grant the admin role within an oracle database procedure to be able to complete the APEX_UTIL.RESET_PASSWORD request.
Thanks
W