Oracle Change Password and set password expiration date

I. Change Password
1) Change Password sql>alter user User01 identified by password;2) Change Password and unlocksql>alter user User01 account unlock identified by P Assword;
3) Unlocking operation
Sql>alter User User01 Account unlock

Two. Set Password expiration
1, check the user's proifle is which, is generally default:

Sql>select username,profile from Dba_users;

2. View the password expiration settings for the specified profile (such as default):

Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

3. Change the password validity period from the default of 180 days to "unlimited":

Sql>alter profile DEFAULT LIMIT password_life_time UNLIMITED;

You do not need to restart the database after you modify it, it takes effect immediately.

4, after the modification, has not been prompted ORA-28002 warning account will not encounter the same prompt;

The account that has been prompted must change the password again, for example:

$sqlplus/as SYSDBA

sql> alter user SMSC identified by < original password >----do not change the new password

Oracle Change Password and set password expiration date