Enable Password Never Expire feature in Oracle

First of all, detect profile name of the target user to set password never expire.


SQL> select profile from DBA_USERS where upper(username) = upper('rman');

PROFILE
------------------------------
DEFAULT

Modify target user profile using this .


SQL> alter profile DEFAULT limit password_life_time UNLIMITED;

Profile altered.

Now, check out user expiry_date.


SQL> select username,expiry_date,account_status from dba_users where upper(username) = upper('rman');

USERNAME                       EXPIRY_DA ACCOUNT_STATUS
------------------------------ --------- --------------------------------
RMAN                                     OPEN


Thanks
A Rahim Khan

Advertisements
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: