Re: Special Characters in Passwords

On May 30, 1:44 pm, "Vladimir M. Zakharychev"
<vladimir.zakharyc...@xxxxxxxxx> wrote:
On May 30, 9:22 pm, Jeff B <jbis...@xxxxxxxxx> 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

.

Relevant Pages

  • Re: Special Characters in Passwords
    ... On May 30, 1:44 pm, "Vladimir M. Zakharychev" ... I need to escape certain characters, or do these characters just not ... You also need to alter punctarray ...
    (comp.databases.oracle.server)
  • Re: Which Is Better?
    ... Vladimir M. Zakharychev wrote: ... statistics for both approaches and compare them to see what could ... Did you capture any other statistics aside from run time ...
    (comp.databases.oracle.misc)
  • Re: Sql Loader - Problem while loading french data
    ... On Aug 17, 1:03 am, "Vladimir M. Zakharychev" ... VARCHAR2 uses BYTE length semantics by default in your database ... Try defining COL2 as VARCHAR2(75 CHAR) and see if the problem will ...
    (comp.databases.oracle.misc)
  • Re: Which Is Better?
    ... Vladimir M. Zakharychev wrote: ... The reason they gave was from a DBA perpspective like it was ... Did they try to capture execution ...
    (comp.databases.oracle.misc)
  • Re: Which Is Better?
    ... Vladimir M. Zakharychev ... N-Networks, makers of Dynamic PSP ...
    (comp.databases.oracle.misc)