Home » SQL & PL/SQL » SQL & PL/SQL » password (oracle 9i)
password [message #378035] Sun, 28 December 2008 00:36 Go to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Hi all,
My user table contains two fields, user_name and password. now if i want to store password in user table. Now

query1:- in user table should it be like '*******' or 'password'? i mean in readable format or not?

query2:- is there any perticular data type for password?

thanks
Re: password [message #378036 is a reply to message #378035] Sun, 28 December 2008 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1) Like you entered it
2) No but there is dbms_crypto package to encrypt your field.

Edit: sorry, dbms_obfuscation_toolkit for your version.

Regards
Michel

[Updated on: Sun, 28 December 2008 01:00]

Report message to a moderator

Re: password [message #378040 is a reply to message #378036] Sun, 28 December 2008 01:35 Go to previous messageGo to next message
modhiyakomal
Messages: 49
Registered: November 2008
Location: US
Member
Thanks a lot Michel.
Re: password [message #378050 is a reply to message #378036] Sun, 28 December 2008 03:38 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Maybe Michel understood you wrong, or I understand Michel wrong, but if your first question was if you should store the password in plain text, the answer is no.
Google for hashed passwords to get an idea how to handle passwords and authentication.
Previous Topic: login comand (merged)
Next Topic: Single row result from multiple sub tables (Many tables join)
Goto Forum:
  


Current Time: Sat Dec 10 07:08:59 CST 2016

Total time taken to generate the page: 0.11844 seconds