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

diff -r cb96d35c46cf -r fc5d1153f3df oracle.rst
--- a/oracle.rst	Thu Jan 10 11:43:56 2019 +0200
+++ b/oracle.rst	Thu Jan 10 13:59:12 2019 +0200
@@ -606,18 +606,28 @@
 Unlock expired password
 =======================
 
+Login as sysdba::
+
+  sqlplus / as sysdba
+
+Check expiration date for user::
+
+  select EXPIRY_DATE from DBA_USERS where USERNAME = 'me';
+
 Connect as sysdba to the database and reset password and unlock user::
 
   alter user <USER> identified by <PASSWORD>;
   alter user <USER> account unlock;
 
-  alter user <LUSER> identified by <PASSWORD> account unlock;
+or with single request::
+
+  alter user <USER> identified by <PASSWORD> account unlock;
 
 To make password lasts infinitely check which profile is used assigned::
 
   select USERNAME, PROFILE from DBA_USERS;
 
-and check settings for this prifile::
+and check settings for this profile::
 
   select * from DBA_PROFILES where PROFILE = 'SA';
 
@@ -631,6 +641,17 @@
   alter profile MY PASSWORD_LIFE_TIME UNLIMITED;
   alter user <USER> profile MY;
 
+To completely disable all password checks::
+
+  alter profile DEFAULT limit COMPOSITE_LIMIT UNLIMITED
+    PASSWORD_LIFE_TIME UNLIMITED
+    PASSWORD_REUSE_TIME UNLIMITED
+    PASSWORD_REUSE_MAX UNLIMITED
+    PASSWORD_VERIFY_FUNCTION NULL
+    PASSWORD_LOCK_TIME UNLIMITED
+    PASSWORD_GRACE_TIME UNLIMITED
+    FAILED_LOGIN_ATTEMPTS UNLIMITED;
+
 Oracle naming conventions
 =========================