Oracle Forms (MOSC)

MOSC Banner

'ORA-28221: REPLACE not specified' when using Forms_DDL?

edited Aug 14, 2009 5:35AM in Oracle Forms (MOSC) 1 commentAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center