Home » SQL & PL/SQL » SQL & PL/SQL » Built in Package for encryption and decryption process. (Oracle 9i)
Built in Package for encryption and decryption process. [message #355182] Thu, 23 October 2008 00:43 Go to next message
apj.ece
Messages: 10
Registered: June 2008
Location: CHENNAI
Junior Member
Hi,
Any built in packages available in oracle 9i for encryption and decryption process.

With Regards,
Jegadeesan.P
Re: Built in Package for encryption and decryption process. [message #355183 is a reply to message #355182] Thu, 23 October 2008 00:44 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
dbms_obfuscation_toolkit

Regards
Michel
Re: Built in Package for encryption and decryption process. [message #355184 is a reply to message #355183] Thu, 23 October 2008 00:53 Go to previous messageGo to next message
apj.ece
Messages: 10
Registered: June 2008
Location: CHENNAI
Junior Member
Thank u for your information..
Re: Built in Package for encryption and decryption process. [message #355187 is a reply to message #355182] Thu, 23 October 2008 00:59 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Also DBMS_CRYPTO in case of 10g.

Smile
Rajuvan.
Re: Built in Package for encryption and decryption process. [message #355286 is a reply to message #355182] Thu, 23 October 2008 06:12 Go to previous messageGo to next message
mail2das.ashok
Messages: 10
Registered: May 2008
Junior Member
Hi,

What is exactly your requirement?


Thanx
Re: Built in Package for encryption and decryption process. [message #355287 is a reply to message #355286] Thu, 23 October 2008 06:16 Go to previous messageGo to next message
apj.ece
Messages: 10
Registered: June 2008
Location: CHENNAI
Junior Member
i need to encryption and the password.
1)encryption password store into database.
2)while login decryption password.
Re: Built in Package for encryption and decryption process. [message #355291 is a reply to message #355182] Thu, 23 October 2008 06:23 Go to previous messageGo to next message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Are you not satisfied with the above two (dbms_obfuscation_toolkit in case or Oracle 9i) functionality ? If so you can create your own package also .


Smile
Rajuvan.
Re: Built in Package for encryption and decryption process. [message #355294 is a reply to message #355287] Thu, 23 October 2008 06:31 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
i need to encryption and the password.
1)encryption password store into database.
2)while login decryption password.


No no no no no no no.

No.

Don't do that - Encryption is, by definition, eversible. If yuo store the information in an encrypted form, it means that users passwords can be decrypted and stolen.

Whatyou want to do is this:
1) Hash the password and store this in the db
2) When the user tries to log in, take the password they enter and hash that.
3) Compare the two hashes

It's the way Oracle do it, and you canbet they've spent more time thinking about this that you or I have.
Previous Topic: computing the cumulative sum on a column
Next Topic: types
Goto Forum:
  


Current Time: Thu Dec 05 18:45:47 CST 2024