Set PASSWORD UNLIMITED for PDB Application Schema

SQL> SELECT dba_users.USERNAME,
dba_users.ACCOUNT_STATUS,
dba_users.EXPIRY_DATE
FROM dba_users
WHERE ACCOUNT_STATUS=’OPEN’;
2 3 4 5
USERNAME ACCOUNT_STATUS EXPIRY_DA
——————————————————————————————————————————– ——————————– ———
NETVERTEXBLR OPE 17-APR-17
PDBADMIN OPE 17-MAR-17
ELITELDAPBLR OPE 21-MAR-17
ELITEPMRO OPE 13-APR-17
ELITEPROXYBLR OPE 17-APR-17
SYSTEM OPE 17-MAR-17
SYS OPE 17-MAR-17

7 rows selected.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> SELECT dba_users.USERNAME,
dba_users.ACCOUNT_STATUS,
dba_users.EXPIRY_DATE
FROM dba_users
WHERE ACCOUNT_STATUS=’OPEN’; 2 3 4 5

USERNAME ACCOUNT_STATUS EXPIRY_DA
——————————————————————————————————————————– ——————————– ———
NETVERTEXBLR OPEN
PDBADMIN OPEN
ELITELDAPBLR OPEN
ELITEPMRO OPEN
ELITEPROXYBLR OPEN
SYSTEM OPEN
SYS OPEN

7 rows selected.

SQL>

If you want to remove password expiry date for your schema then you have to use “ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;”

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 )

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.