oracle.rst
changeset 2341 d241ba9f9366
parent 2340 fc5d1153f3df
child 2569 8f4415990863
equal deleted inserted replaced
2340:fc5d1153f3df 2341:d241ba9f9366
   611   sqlplus / as sysdba
   611   sqlplus / as sysdba
   612 
   612 
   613 Check expiration date for user::
   613 Check expiration date for user::
   614 
   614 
   615   select EXPIRY_DATE from DBA_USERS where USERNAME = 'me';
   615   select EXPIRY_DATE from DBA_USERS where USERNAME = 'me';
       
   616   select USERNAME, ACCOUNT_STATUS from DBA_USERS where USERNAME = 'me';
   616 
   617 
   617 Connect as sysdba to the database and reset password and unlock user::
   618 Connect as sysdba to the database and reset password and unlock user::
   618 
   619 
   619   alter user <USER> identified by <PASSWORD>;
   620   alter user <USER> identified by <PASSWORD>;
   620   alter user <USER> account unlock;
   621   alter user <USER> account unlock;