Home » Other » Training & Certification » Password Verify Function.
Password Verify Function. [message #260712] Mon, 20 August 2007 14:52 Go to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

Can you help me with the password verify function with 2 conditions being satisfied
1. should not end with numbers.
2. should not have username in the password text ..

-Sai J
Re: Password Verify Function. [message #260715 is a reply to message #260712] Mon, 20 August 2007 14:58 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
$ORACLE_HOME/rdbms/admin/utlpwdmg.sql

Regards
Michel
Re: Password Verify Function. [message #260719 is a reply to message #260715] Mon, 20 August 2007 15:06 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member

it doesnt have these conditions in it .. i need one which will not allow username anywhere in the password and also numbers must be embedded inside the password..should not be at the beginning / ending ..

Re: Password Verify Function. [message #260723 is a reply to message #260719] Mon, 20 August 2007 15:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PL/SQL User's Guide and Reference

Regards
Michel
Re: Password Verify Function. [message #260727 is a reply to message #260719] Mon, 20 August 2007 15:16 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
1. should not end with numbers.

ASCII(SUBSTR('your_password', -1)) may not be between 48 and 57


2. should not have username in the password text.

INSTR(upper('your_password'), USER) = 0
Previous Topic: Level in sequence query..
Next Topic: Error creating database in windows xp with db_block_size = 8192 in oracle 9i
Goto Forum:
  


Current Time: Sun Dec 11 06:34:04 CST 2016

Total time taken to generate the page: 0.04008 seconds