OraFAQ Forum: Security » encrypt password while inserting into table

Home » RDBMS Server » Security » encrypt password while inserting into table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

encrypt password while inserting into table [message #33197]

Sat, 25 September 2004 08:05

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

�

Report message to a moderator

Re: encrypt password while inserting into table [message #33201 is a reply to message #33197]

Sat, 25 September 2004 20:20

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

Take a look at the dbms_obfuscation package.

Report message to a moderator

Re: encrypt password while inserting into table [message #110761 is a reply to message #33197]

Thu, 10 March 2005 01:30

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
/

Report message to a moderator

Re: encrypt password while inserting into table [message #110834 is a reply to message #33197]

Thu, 10 March 2005 11:37

Frank
Messages: 7901
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

Report message to a moderator

Re: encrypt password while inserting into table [message #110886 is a reply to message #33201]

Thu, 10 March 2005 17:03

Maaher
Messages: 7065
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:26:41 CDT 2024