Re: Special Characters in Passwords

On May 30, 1:44 pm, "Vladimir M. Zakharychev" <vladimir.zakharyc..._at_gmail.com> wrote:
> On May 30, 9:22 pm, Jeff B <jbis..._at_yahoo.com> wrote:
>
>
>
>
>
> > Hello,
>
> > I have edited Oracle's standard verify_function created by
> > utlpwdmg.sql to include the following special characters: ~ . ^ { }
> > [ ] | \
> > Password containing ~ or { or } work just fine. For the others, I
> > receive the following error when trying to change my password using a
> > command line:
>
> > SQL> password
> > Changing password for JBISCH
> > Old password:
> > New password:
> > Retype new password:
> > ERROR:
> > ORA-28003: password verification for the specified password failed
> > ORA-06502: PL/SQL: numeric or value error: character string buffer too
> > small
>
> > Here is the piece of code that I altered from the verify_function:
>
> > punctarray:='!"#$%&()~``*+,-/:;<=>?_{}\\.^|[]';
>
> > Could it be the order in which I have the characters are listed, or do
> > I need to escape certain characters, or do these characters just not
> > work for oracle passwords?
>
> > I am using Oracle 9.2.0.7 on Unix AIX 4.3.3.
> > Any help would be appreciated.
>
> > Thanks,
> > Jeff
>
> Is that the only place you altered? You also need to alter punctarray
> declaration and increase its max length of 25 to, say, 35, so that it
> can accommodate added punctuation characters.
>
> Regards,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com- Hide quoted text -
>
> - Show quoted text -

That did the trick! Thank you very much!!!!!!!!!!!

~Jeff Received on Thu May 31 2007 - 11:05:43 CDT