Re: PASSWORD EXPIRING MGS??

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Thu, 22 Apr 2004 19:46:35 +0200
Message-ID: <u51g80ll7roan1b7169f74j3as327hjops@4ax.com>

On 22 Apr 2004 08:02:11 -0700, steven.fox_at_dfas.mil (Steven Fox) wrote:

>I have created a test profile:
>CREATE PROFILE "TEST_3DAYS"
> LIMIT CPU_PER_SESSION DEFAULT CPU_PER_CALL DEFAULT
> CONNECT_TIME DEFAULT IDLE_TIME DEFAULT SESSIONS_PER_USER
> DEFAULT LOGICAL_READS_PER_SESSION DEFAULT
> LOGICAL_READS_PER_CALL DEFAULT PRIVATE_SGA DEFAULT
> COMPOSITE_LIMIT DEFAULT FAILED_LOGIN_ATTEMPTS 3
> PASSWORD_LOCK_TIME DEFAULT PASSWORD_GRACE_TIME 3
> PASSWORD_LIFE_TIME 3 PASSWORD_REUSE_MAX UNLIMITED
> PASSWORD_REUSE_TIME 365 PASSWORD_VERIFY_FUNCTION
> VERIFY_FUNCTION
>When signing into SQLPLUS after the password expires I would expect a
>message to change password but is recieving none.....

init.ora parameter resource_limit must be set to true to check for any profile limit.
Could please drop the caps and stop shouting?

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Apr 22 2004 - 12:46:35 CDT