oracle.rst
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::