Re-open expired oracle database account without change password


SELECT username, account_status, expiry_date
 FROM dba_users
 WHERE username = 'DCS_APP';
-------------------------------------------
USERNAME ACCOUNT_STATUS EXPIRY_DATE
TEST EXPIRED 22-JAN-15 11:31:50
get the existing password
SELECT DBMS_METADATA.get_ddl ('USER', 'DCS_APP')
FROM DUAL;
-------------------------------------------
 CREATE USER "DCS_APP" IDENTIFIED BY VALUES 'S:79B1417837DCF0FBFACEFB10D7DBDC7B7EA63CC986036567BDCBA144B940;7A0F2B316C212D67'
 DEFAULT TABLESPACE "USERS"
 TEMPORARY TABLESPACE "TEMP"
 PASSWORD EXPIRE
and
ALTER USER "DCS_APP" IDENTIFIED BY VALUES 'S:79B1417837DCF0FBFACEFB10D7DBDC7B7EA63CC986036567BDCBA144B940;7A0F2B316C212D67';
chek status again
SELECT username, account_status, expiry_date
 FROM dba_users
 WHERE username = 'DCS_APP';
-------------------------------------------
USERNAME ACCOUNT_STATUS EXPIRY_DATE
TEST OPEN 20-Sep-15 11:36:47
Advertisements

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: