# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1547121604 -7200
# Node ID d241ba9f936648dfbf64560d5f34a683e827a6e9
# Parent  fc5d1153f3dfc84bc8848401d81e198744f4ef2b
Check expiration date for user.

diff -r fc5d1153f3df -r d241ba9f9366 oracle.rst
--- 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::