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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
74,528 views