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 extend expiration date of an user

791045Apr 29 2011 — edited Apr 29 2011

Oracle 11g 11.2.00

Our first Oracle system was installed in the end of last year...

Some passwords are supposed to expire during this weekend and I wouldn't like this to happen now.

I confirmed that the users i want to change are using the same profile : DEFAULT

And for this profile I have the values :

RESOURCE NAME : PASSWORD_LIFE_TIME
RESOURCE : PASSWORD
LIMIT 180

Can I just update this LIMIT row with an update command ?

update dba_profiles set limit = 180 where profile = 'DEFAULT' ;

Is it possible to do this ? Is it safe ?

Ed

This post has been answered by 734879 on Apr 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 27 2011

Added on Apr 29 2011

#general-database-discussions

12 comments

48,424 views