Discussions
Categories
- 385.5K All Categories
- 5.1K Data
- 2.5K Big Data Appliance
- 2.5K Data Science
- 453.4K Databases
- 223.2K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 47 Multilingual Engine
- 606 MySQL Community Space
- 486 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.2K ORDS, SODA & JSON in the Database
- 585 SQLcl
- 4K SQL Developer Data Modeler
- 188K SQL & PL/SQL
- 21.5K SQL Developer
- 46 Data Integration
- 46 GoldenGate
- 298.4K Development
- 4 Application Development
- 20 Developer Projects
- 166 Programming Languages
- 295K Development Tools
- 150 DevOps
- 3.1K QA/Testing
- 646.7K Java
- 37 Java Learning Subscription
- 37.1K Database Connectivity
- 201 Java Community Process
- 108 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.4K Java EE (Java Enterprise Edition)
- 22 Java Essentials
- 176 Java 8 Questions
- 86K Java Programming
- 82 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 208 Java User Groups
- 25 JavaScript - Nashorn
- Programs
- 667 LiveLabs
- 41 Workshops
- 10.3K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 6K Other Languages
- 2.3K Chinese
- 207 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 474 Portuguese
Password reset email contains username - any way to remove it?

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?
Answers
-
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
-
Try to find the RESET_PW function in a database and modify it according to you needs.
-
Hilary Farrell-Oracle Software Development Senior Manager Dublin, IrelandMember Posts: 2,417 Employee
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
-
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