4 Replies Latest reply: Feb 7, 2012 4:51 PM by User11831917-Oracle RSS

    How do I set up passwords to NEVER  expire?

    244142
      How do I set up passwords to NEVER expire?

      as shown below, this SQL didn't work.

      Yes I even tried shutting down the database and restarting...help I only have 6 days left!

      Of course this is an unsafe practice but I am not doing a database for the FBI.

      [oracle@localhost ~]$ sqlplus system/rumprocella

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 18 11:44:34 2010

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      ERROR:
      ORA-28002: the password will expire within 6 days



      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> ALTER PROFILE DEFAULT LIMIT
      FAILED_LOGIN_ATTEMPTS UNLIMITED
      PASSWORD_LIFE_TIME UNLIMITED;
      2 3
      Profile altered.

      SQL>
      SQL> commit;

      Commit complete.

      SQL> quit
      Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      [oracle@localhost ~]$ sqlplus system/rumprocella

      SQL*Plus: Release 11.1.0.6.0 - Production on Thu Nov 18 11:45:45 2010

      Copyright (c) 1982, 2007, Oracle. All rights reserved.

      ERROR:
      ORA-28002: the password will expire within 6 days



      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL>