OraFAQ Forum: Training & Certification » Password Verify Function.

Home » Other » Training & Certification » Password Verify Function.

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

Password Verify Function. [message #260712]

Mon, 20 August 2007 14:52

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

Report message to a moderator

Re: Password Verify Function. [message #260715 is a reply to message #260712]

Mon, 20 August 2007 14:58

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

$ORACLE_HOME/rdbms/admin/utlpwdmg.sql

Regards
Michel

Report message to a moderator

Re: Password Verify Function. [message #260719 is a reply to message #260715]

Mon, 20 August 2007 15:06

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 ..

Report message to a moderator

Re: Password Verify Function. [message #260723 is a reply to message #260719]

Mon, 20 August 2007 15:12

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

PL/SQL User's Guide and Reference

Regards
Michel

Report message to a moderator

Re: Password Verify Function. [message #260727 is a reply to message #260719]

Mon, 20 August 2007 15:16

Littlefoot
Messages: 21807
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

Report message to a moderator

Previous Topic:	Level in sequence query..
Next Topic:	Error creating database in windows xp with db_block_size = 8192 in oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 09:01:01 CDT 2024