author | Oleksandr Gavenko <gavenkoa@gmail.com> |
Thu, 10 Jan 2019 14:00:04 +0200 | |
changeset 2341 | d241ba9f9366 |
parent 2340 | fc5d1153f3df |
child 2342 | fb128fcaf50a |
oracle.rst | file | annotate | diff | comparison | revisions |
--- 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::