Password Checking
All: I am looking for an algorithm that will verify that a pasword meets minimum requirements (like >8 chars, mix of chars & nbrs, != username, etc), but am just feeling too darn lazy to write one myself. Can anyone on the list help me out by pointing me to a good one? Thanks Kevin Toepke [EMAIL PROTECTED] The information in this electronic mail message is Trilegiant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Trilegiant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Offline doubt - Password checking in Oracle..
If user is connected to Oracle and is able to use Your function, You shouldn't have any reason to check the old password. or If user is not connected when passing those parameters, let Oracle check, if the password is correct when (application) try to connect or If old password is a Sybase password, You should check it against Sybase db, not Oracle. HTH Jorma > -Original Message- > From: ext Arul kumar [mailto:[EMAIL PROTECTED]] > Sent: 02 February, 2001 8:45 > To: Multiple recipients of list ORACLE-L > Subject: Offline doubt - Password checking in Oracle.. > > > Hi Gurus, > > I am working on a Sybase to Oracle migration project where i need to > write a function which accepts username , old password and > new password > as parameters and modifies the account(Oracle Schema ) with the new > password. > If the password is correct, then only password modification > should take > place. > > Now, my question is : > > How to validate the user given password as correct or not? > (becos Oracle > stores password by encrypting it!). > > Any suggestions will be of great help to me. > > TIA, > Arul. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arul kumar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Offline doubt - Password checking in Oracle..
Hi Gurus, I am working on a Sybase to Oracle migration project where i need to write a function which accepts username , old password and new password as parameters and modifies the account(Oracle Schema ) with the new password. If the password is correct, then only password modification should take place. Now, my question is : How to validate the user given password as correct or not? (becos Oracle stores password by encrypting it!). Any suggestions will be of great help to me. TIA, Arul. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arul kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).