Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set database user password to never expire

user6902559Jun 30 2010 — edited Apr 13 2011
Hello all,

I have a linux server with Oracle 11g installed which is used primarily for testing by a few developers and QA folks. I want to set the DB user password to never expire. I have run the following (which works on a windows machine) but the password still states that it will expire in 7 days. Is there something else I can do to 'force' the pw to infinity? I've tried stopping shutting down the DB, stopping / restarting listener...

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
select * from dba_profiles where profile = 'DEFAULT' and resource_name LIKE 'PASSWORD_LIFE_TIME';
"PROFILE" "RESOURCE_NAME" "RESOURCE_TYPE" "LIMIT"
"DEFAULT" "PASSWORD_LIFE_TIME" "PASSWORD" "UNLIMITED"

select profile from dba_users where username='TEST';
"PROFILE"
"DEFAULT"

select username, account_status, to_char(expiry_date, 'DD-MM-YYYY') EXP_DATE from dba_users where username = 'TEST';
"USERNAME" "ACCOUNT_STATUS" "EXP_DATE"
"TEST" "OPEN" ""

Help appreciated.
This post has been answered by rajeysh on Jun 30 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2011
Added on Jun 30 2010
18 comments
79,566 views