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!

change EXPIRY_DATE for existing user

774169May 20 2010 — edited May 21 2010

Hello dba-gurus !

Since I'm a beginner (and the real dba is on holiday) maybe this is a stupid question :

How can I change the value of EXPIRY_DATE ??
The Backup user account "rman" is expired.

when i query dba_users i'll get :
USERNAME EXPIRY_DA ACCOUNT_STATUS
RMAN 20-MAY-10 EXPIRED

is there away to disable expiration or set the expiration to a date of my choice ?
All i found in google was default profile related.
Does this also effect existing users ?

regards

This post has been answered by Rajesh Lathwal on May 20 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 18 2010

Added on May 20 2010

#general-database-discussions

3 comments

6,964 views