Allow Oracle users to have a password that never expires

SQL * Plus: Release 11.2.0.1.0 Production on Mon Feb 18 15:42:14 2013

OS: Linux node 2.6.32-200.13.1.el5uek #1 SMP Wed Jul 27 21:02:33 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux

Due to application requirements, some user passwords cannot expire, and they must be set to never expire. Perform the following experiment:

SQL> create user test identified by test;

User created.

SQL> select username, account_status, expiry_date, profile from dba_users where username = 'test ';

USERNAME ACCOUNT_STATUS EXPIRY_DA PROFILE
-----------------------------------------------------------------------------------------------------
Test open 17-AUG-13 DEFAULT

SQL> select sysdate from dual;

SYSDATE
---------
18-FEB-13

The password is valid for six months.

The parameter used to control the validity period of a user's password is password_life_time. This parameter cannot be viewed through show parameter. in the user's profile, the profile is default by default when a user is created, we can check which parameters are controlled in the default profile:

SQL> select * from dba_profiles where profile = 'default ';

PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180

PROFILE RESOURCE_NAME RESOURCE LIMIT
--------------------------------------------------------------------------------------------------------------
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7

16 rows selected.

We can see that the password_life_time parameter is in it, and the value is 180, in days.

1 2 Next Page