Question:
my professora ๐I want to create a page what logged in users can change their passwords.
User ID is taken from
APP_USER
. And I want to update the registration information with the password entered in the text box :P9901_NEW_PASSWORD
.Can I implement this with the standard functionality in Oracle APEX? Or tell me how to encrypt the table to be updated and the password?
Thanks for your kindness to read this question ๐
Answer:
If the authentication is apex authentication (usernames/passwords are defined in apex), then the password can be changed using theAPEX_UTIL
api, procedure CHANGE_CURRENT_USER_PW
Here is an example:
In a business situation this is not common. Usually the authentication is taken care of by a central identity provider and users/passwords are not managed in the apex application.
If you have better answer, please add a comment about this, thank you!