Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Password reset email contains username - any way to remove it?

MH1729Feb 7 2017 — edited Feb 8 2017

In our system, we have a user management page, where administrators can reset users' passwords, and of course they can reset them themselves on the login screen.

At the moment, we are using the APEX_UTIL.RESET_PW(<username>,<message>) function to send out new password emails, which includes both the login name and password.

For compliance reasons, we want to stop sending the username out in these emails, but there doesn't seem to be a way to do this with the RESET_PW function.

Is there a way to modify the RESET_PW function so that it does not include the username?

If not, is there another way to reset a user's password and send an email out to them, with only the password in the message?

Comments

Bas de Klerk

Hi,

I don't think apex provides that functionality....yet (btw you did not mention which apex release you are on which is always info #1 ).

Have your considered using apex_util.reset_password and then send an email via apex_mail, this way you can customize the mail 100% ?

From apex >= 5.0 this only works when logged in as an admin user, to implement this on a logon page you need to implement a database job which handles the password reset since the unauthenticated session cannot do that using apex_util.password

Regards

Bas

Marcin Izdebski

Try to find the RESET_PW function in a database and modify it according to you needs.

Hi,

Please note that it is not advisable to modify the APEX installed objects.  Aside from it resulting in your instance being unsupported, it could impact the behaviour of your install, and you'll also lose your changes when you upgrade to the next version of APEX.

Regards,

Hilary

2 people found this helpful
Marcin Izdebski

Hi HIlary,

There is a saying; if you are scarred don't go to the forest ...

You can register your change and deploy the code every time you upgrade APEX the same way you would deploy your application builds. It's a matter of releases notes. Besides APEX is straight forward application and you are free to modify it to your needs. Personally I don't know Oracle client who has not customised oracle products according to its requirements.

Cheers!

Marcin

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 8 2017
Added on Feb 7 2017
#apex-discussions, #email, #password
4 comments
274 views