How do I set up passwords to NEVER expire?
244142Nov 18 2010 — edited Feb 7 2012How 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>