Re: verify password func.

From: <Kenneth>
Date: Mon, 31 Mar 2003 19:05:12 GMT
Message-ID: <3e888edf.41593648@news.inet.tele.dk>

On Mon, 31 Mar 2003 12:47:02 -0500, "Hoang C" <hoang_c_at_bls.gov> wrote:

>Do you have any password verify function to check user password? Ex:
>length:12 chars, contain at least 2 numbers, 2 punct chars. It is good to
>have it because some users might forget to set it.
>
>

Not quite clear, what you want. Normally, such password checks are done through the PASSWORD_VERIFY_FUNCTION parameter in profile definitions :

create PROFILE myprofile LIMIT

PASSWORD_LIFE_TIME 60
PASSWORD_GRACE_TIME 10
PASSWORD_REUSE_TIME 1800
PASSWORD_REUSE_MAX UNLIMITED

FAILED_LOGIN_ATTEMPTS 3
PASSWORD_LOCK_TIME 1
PASSWORD_VERIFY_FUNCTION vv;

alter user myuser profile myprofile;
-- The myuser's password is now checked with "vv"

Where the "vv" function is a simple PL/SQL function of the following form :

create or replace function vv(        username varchar2, 
                                              new_password varchar2,

                                              old_password  varchar2)

return boolean
as
begin

• Check password, here just a simple length check. return (length(new_password) > 10); end vv; /

Hope that was what you wanted.

• Kenneth Koenradt

Received on Mon Mar 31 2003 - 13:05:12 CST