Home about IT Motivation Course Sales Project About Me

Monday, December 26, 2011

expired password on Oracle 11g

please login as system or dba

to show status account :
select username, account_status, expiry_date, lock_date from dba_users;

to set password un expired:
alter profile default limit password_life_time unlimited;

if the password exired then the user locked:
alter user scott account unlock;