In a designer generated application on 8.1.7 database. I am developing a module where users can change there own passwords. This is updated on a table with user's info.
How can I issue the "Alter user ____ identified by ____"statement when this happens?
A table level trigger will not allow this.