changeset 2341 | d241ba9f9366 |
parent 2340 | fc5d1153f3df |
child 2569 | 8f4415990863 |
--- a/oracle.rst Thu Jan 10 13:59:12 2019 +0200 +++ b/oracle.rst Thu Jan 10 14:00:04 2019 +0200 @@ -613,6 +613,7 @@ Check expiration date for user:: select EXPIRY_DATE from DBA_USERS where USERNAME = 'me'; + select USERNAME, ACCOUNT_STATUS from DBA_USERS where USERNAME = 'me'; Connect as sysdba to the database and reset password and unlock user::