Check expiration date for user.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 10 Jan 2019 14:00:04 +0200
changeset 2341 d241ba9f9366
parent 2340 fc5d1153f3df
child 2342 fb128fcaf50a
Check expiration date for user.
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::