'ORA-28221: REPLACE not specified' when using Forms_DDL?
We have recently implemented a PASSWORD_VERIFY_FUNCTION which has caused problems with an existing password change form. The form uses Forms_DDL to run an ALTER USER function but from reading this article I understand that this is not possible if there is a PASSWORD_VERIFY_FUNCTION. In order to get it to work, I would either have to grant the ALTER_USER privilege to all users, or use a REPLACE function to effectively re-create the user to change a password.
Granting the ALTER_USER privilege to all users doesn't seem like a very safe option.
Are there any implications of using the REPLACE function? If the user's account gets re-created while they're in a session will they get kicked out of Forms whilst changing their own password?
Granting the ALTER_USER privilege to all users doesn't seem like a very safe option.
Are there any implications of using the REPLACE function? If the user's account gets re-created while they're in a session will they get kicked out of Forms whilst changing their own password?
0