Home » RDBMS Server » Security » encrypt password while inserting into table
encrypt password while inserting into table [message #33197] Sat, 25 September 2004 08:05 Go to next message
Mahesh P
Messages: 69
Registered: September 2004
Member
hai dudes,

i am developing an application which uses login page.i want to store only the encrypted password into the table rather than the readable form of password(useful for guarding the users account accessing by other people looking into table).is there any oracle's function to do that.I am using oracle 9i.

plz help me

thanks

regards,

Mahesh P

 
Re: encrypt password while inserting into table [message #33201 is a reply to message #33197] Sat, 25 September 2004 20:20 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Take a look at the dbms_obfuscation package.
Re: encrypt password while inserting into table [message #110761 is a reply to message #33197] Thu, 10 March 2005 01:30 Go to previous messageGo to next message
binzaman
Messages: 30
Registered: March 2005
Location: Lahore
Member
yup u can encrypt / decrypt by using this command

SELECT TRANSLATE(
'HELLO WORLD', -- Message to encode
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ',
'1234567890!@#$%^&*()-=_+;,.') ENCODED_MESSAGE
FROM DUAL
/

SELECT TRANSLATE(
'85@@%._%*@4', -- Message to decode
'1234567890!@#$%^&*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ') DECODED_MESSAGE
FROM DUAL
/
Re: encrypt password while inserting into table [message #110834 is a reply to message #33197] Thu, 10 March 2005 11:37 Go to previous messageGo to next message
Frank
Messages: 7893
Registered: March 2000
Senior Member
That is about as good an encryption as the lower() function (with upper() as decryption) is...

Look at Todd's reply for a real solution, or use database-accounts. No need to store passwords, Oracle will take care of that.

hth
Re: encrypt password while inserting into table [message #110886 is a reply to message #33201] Thu, 10 March 2005 17:03 Go to previous message
Maaher
Messages: 7064
Registered: December 2001
Senior Member
Todd Barry wrote on Sun, 26 September 2004 03:20

Take a look at the dbms_obfuscation package.

As of 10g, Oracle recommends the DBMS_CRYPTO package.

MHE
Previous Topic: About connection with sysdba
Next Topic: Help me Password for OraApp1158
Goto Forum:
  


Current Time: Mon Aug 15 08:08:05 CDT 2022