Hi,
This automation needs to call APEX_UTIL.RESET_PASSWORD (actually also CREATE_USER and REMOVE_USER), which as stated in Oracle Documentation needs Administrative Privileges. Automations seems to run, by default, with user NOBODY, which has no such privileges.
So I've tried several things but I get the same ORA error every time. This is what I've tried:
- Turn on all Runtime API Usage in the Application\Security settings for the application the automation belongs to.
- Call the RESET_PASSWORD both at the automation's Action level and at a Package called from the automation's action.
- Use the APEX_UTIL.SET_SECURITY_GROUP_ID to the Workspace ID of the automation's application.
- Use the APEX_CUSTOM_AUTH.SET_USER() with a user that is a Workspace Administrator. If I call the RESET_PASSWORD from the APEX application (e.g. clicking a page button) while connected with this user, it works and the password is reset. If call it from the automation, it doesn't, error is the same for that user instead of NOBODY.
The idea is that End-Users can file Reset-Password Requests from an APEX application, then the requests will be attended by the Automation running with the required Administrative privileges for that.
Any guidance on how to accomplish this will be greatly appreciated.
APEX is 22.2 running on an ADB on OCI.