Re: Profiles and password limits in 9i

For that to happen you need to create the user with 
the 'PASSWORD EXPIRE' clause.
14:21:41 rsysdevdb.radisys.com <http://rsysdevdb.radisys.com> - 
js001292@dv03 SQL> create user trashme profile barebones
14:21:49 2 identified by password
14:22:01 3 password expire
14:22:10 4 /

User created.

14:22:10 rsysdevdb.radisys.com <http://rsysdevdb.radisys.com> - 
js001292@dv03 SQL> connect trashme/password
ERROR:
ORA-28001: the password has expired


Changing password for trashme
New password:


On 4/22/05, Ehresmann, David <David.Ehresmann@xxxxxx> wrote:
> 
> This profile forced users to change their password upon first login in
> 8i. In 9i it is not forcing that behavior. I have looked on metalink
> and read the notes 114930.1, 1079860.1, and 162818.1. Does anybody know
> why or has had the same experience?
> PROFILE FAILED_LOGIN_ATTEMPTS 5
> PROFILE PASSWORD_LIFE_TIME 90
> PROFILE PASSWORD_REUSE_TIME
> UNLIMITED
> PROFILE PASSWORD_REUSE_MAX 5
> PROFILE PASSWORD_VERIFY_FUNCTION DEFAULT
> PROFILE PASSWORD_LOCK_TIME 9999
> PROFILE PASSWORD_GRACE_TIME 5
> 
> Thanks,
> 
> David Ehresmann
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 



-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Other related posts: