Re: Algorithm to create an encrypted Oracle password
Date: Sat, 12 Apr 2008 13:18:28 -0700 (PDT)
On Apr 9, 6:41 am, "news.verizon.net" <kenned..._at_verizon.net> wrote:
> "Norbert Pürringer" <thalio..._at_graffiti.net> wrote in message
> news:32f18475-513d-434b-8c76-fe9eca8ceb3a_at_a23g2000hsc.googlegroups.com...> Hello there,
> > do you know an algorithm for me, which is able to encrypt passwords,
> > which are compatible Oracle passwords? There is a maximum length
> > limitation in Oracle (30 chars) and the algorithm should not produce
> > an encrypted password longer than 30 characters, if the clear text
> > password is less than or equals 30 characters. The best algorithm for
> > me would be one, which always creates an encrypted password with a
> > length of 30 characters.
> > I need the algorithm for a C# (.NET) application.
> > Thank you,
> > Norbert
> Oracle does not encrypt the password. It creates a hash. When you log in
> it hashes what you supply as a password and compares that with what is
> stored. Why do you need to know the hash algorithum for Oracle? There are
> plenty of good ones publicaly available.
Norbert, depending on your unnamed version of Oracle and exactly what you are intending to do Oracle provides encryption routines that can be used to encrypt and decrypt data. These might be of use to you.
HTH -- Mark D Powell -- Received on Sat Apr 12 2008 - 15:18:28 CDT