3.4 Change Default Password Settings

Oracle Database includes new default password-related settings.

• Edit init.ora to turn off case-sensitive database logon as follows:

  sec_case_sensitive_logon=false
  

• To prevent database password expiration, log in to SQL*Plus as a superuser and enter:

  ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;