Re: Help - profile and verify_function

If the user is using the 'alter user identified by password' command to change his password, then the verification function is not being used.

Troy Meyerink
Oracle DBA
Raytheon

"Knut Talman" <knut.talman_at_mytoys.de> wrote in message news:3CBEE303.B289F9EC_at_mytoys.de...
> > I've got a user with minimal amout of priviliges and i want him to be
> > able to change his own password. Everything is fine untill I enable
> > verify_function. If the verify_function is on (i mean if the users
> > profile has the limit password_verify function set to verify_function
> > that can be found in utlpwdmg.sql script), user can not change his own
> > password. He can do it only when hi's got the alter user privilige.
> > The error that appeares is ORA-28003: password verification for the
> > specified password failed, with no other explanation - it seems there
> > was a problem in ececuting verify_fuction. The new password complexity
> > is ok, it complies every limitation (length, contains one digit, one
> > character and one punctuation ...).
> > Do you know what is wrong? Thank you for help.
>
> Sounds like the execution right for the verify function is missing.
>
> Regards,
>
> Knut
Received on Thu Apr 18 2002 - 11:06:56 CDT