Check expiration date for user,
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 10 Jan 2019 13:59:12 +0200
changeset 2340 fc5d1153f3df
parent 2339 cb96d35c46cf
child 2341 d241ba9f9366
Check expiration date for user,
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
 =========================