OraFAQ Forum: Security » Password complexity

Home » RDBMS Server » Security » Password complexity (Oracle 11g on Aix6.1)

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

Password complexity [message #626600]

Wed, 29 October 2014 16:21

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi Guys,

i need to create a password verify function so as to associate a profile named User_profile the which will be work on basis on two things.

1)password should be greater than 7 characters
2)password should be alpha & Numeric(number)

so could you guys assist me to create the function ?

i do have a verify function like that,please validate below function and tell me what needs to be added for alpha & number must be come in password

CREATE OR REPLACE FUNCTION Verify_function (
username VARCHAR2,
password VARCHAR2,
old_password VARCHAR2)
RETURN BOOLEAN AS
BEGIN
IF LENGTH(password) < 7 THEN
RETURN FALSE;
ELSE
RETURN TRUE;
END IF;
END my_passenf_function;
/

i do have some function like

CREATE PROFILE dbuser_profile LIMIT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
CONNECT_TIME UNLIMITED
IDLE_TIME UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
COMPOSITE_LIMIT UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME 30 ---password expire after 90 days
PASSWORD_REUSE_TIME 120 ---- Number of days until a specific password can be reused
PASSWORD_REUSE_MAX 12 ------ The number of changes required before a password can be reused
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 5 ---the password expires if it is not changed within the grace period, and further connections are rejected
PASSWORD_VERIFY_FUNCTION Verify_function;

thanks & Regards.

Report message to a moderator

Re: Password complexity [message #626602 is a reply to message #626600]

Wed, 29 October 2014 17:07

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

I notice that you have posted many questions here, but have never given any thanks for answers. You have also never attempted to assist anyone else.

So all I shall say now is "have you looked at the demonstration code provided in the utlpwdmg.sql script?"

Report message to a moderator

Re: Password complexity [message #626614 is a reply to message #626602]

Thu, 30 October 2014 01:00

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

... In addition, you make no effort to format your post as requested.
I think you no more deserve to be helped.

Report message to a moderator

Re: Password complexity [message #626745 is a reply to message #626602]

Sat, 01 November 2014 14:53

oradba123
Messages: 86
Registered: June 2009
Location: india

Member

Hi John,

let me first say thank you very much for reply. yes i have checked it but i don't find passowrd like alpha & number.

thanks & Regards
younus

Report message to a moderator

Re: Password complexity [message #626746 is a reply to message #626745]

Sat, 01 November 2014 15:01

John Watson
Messages: 8997
Registered: January 2010
Location: Global Village

Senior Member

You didn't check it very well.

Report message to a moderator

Previous Topic:	UTL_HTTP and TLS
Next Topic:	Row level security

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 26 07:26:48 CST 2026