Home » RDBMS Server » Security » Password complexity (Oracle 11g on Aix6.1)
Password complexity [message #626600] Wed, 29 October 2014 16:21 Go to next message
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.
Re: Password complexity [message #626602 is a reply to message #626600] Wed, 29 October 2014 17:07 Go to previous messageGo to next message
John Watson
Messages: 7937
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?"
Re: Password complexity [message #626614 is a reply to message #626602] Thu, 30 October 2014 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 66445
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Password complexity [message #626745 is a reply to message #626602] Sat, 01 November 2014 14:53 Go to previous messageGo to next message
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
Re: Password complexity [message #626746 is a reply to message #626745] Sat, 01 November 2014 15:01 Go to previous message
John Watson
Messages: 7937
Registered: January 2010
Location: Global Village
Senior Member
You didn't check it very well.
Previous Topic: UTL_HTTP and TLS
Next Topic: Row level security
Goto Forum:
  


Current Time: Mon Jun 24 09:08:14 CDT 2019