--- 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
=========================