Re: Special Characters in Passwords

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 Received on Wed May 30 2007 - 12:44:45 CDT