Discussions
Categories
- 385K All Categories
- 2.6K Data
- 582 Big Data Appliance
- 2K Data Science
- 452.1K Databases
- 222.3K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 575 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 575 SQLcl
- 4K SQL Developer Data Modeler
- 187.7K SQL & PL/SQL
- 21.5K SQL Developer
- 12 Data Integration
- 12 GoldenGate
- 297.7K Development
- 3 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 294.3K Development Tools
- 118 DevOps
- 3.1K QA/Testing
- 646.4K Java
- 30 Java Learning Subscription
- 37K Database Connectivity
- 185 Java Community Process
- 107 Java 25
- 22.2K Java APIs
- 138.3K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 172 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
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 583 LiveLabs
- 41 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.6K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 191 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 240 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.
-
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