How to re-open expired or EXPIRED(GRACE) Oracle database account without changing the password
Oracle open a account without changing password for EXPIRED(GRACE) .
oracle EXPIRED(GRACE)
Oracle password EXPIRED
oracle ACCOUNT_STATUS EXPIRED(GRACE)
oracle ACCOUNT_STATUS EXPIRED
set linesize 200 pagesize 200 col username for a20 select USERNAME,EXPIRY_DATE,ACCOUNT_STATUS from dba_users where 1=1 and USERNAME like 'ANUJ%'; USERNAME EXPIRY_DATE ACCOUNT_STATUS -------------------- -------------------- -------------------------------- ANUJ Feb-12-2017 03:06:30 OPEN ANUJ1 Aug-17-2016 05:23:26 EXPIRED <<<<<----- ANUJ1 account is expired . Run following Sql to create a sql set linesize 2000 longchunksize 300 long 5000 pagesize 0 select 'alter user ' || su.name || ' identified by values' || ' ''' || spare4 || ';' || su.password || ''';' from sys.user$ su , dba_users du where su.name = du.username and username='ANUJ1' -- and ACCOUNT_STATUS like '%GRACE%' ; execute this sql .. alter user ANUJ1 identified by values 'S:B14311128BF87FFD1643BEF65E94695CAE0AF024E2A19A1EDF939E4DB739;H:895AC434525B471C4EAFEDDCE7A92E68;T:83572A338D2763FE2DDBF96C865557E58B916A1CD9EABA882E2FFF48C4CD69DA08B10582D0AD4FE3DC5CAC43322492C786B47C2BD12F3BA7136065D636BA9A8159AD3EB71BEFC2D754E253D09E5E849C;4A4D264BE7A4FEB0'; User altered. Now user is alterted with old password Now Check the status is open ... set linesize 200 pagesize 200 col username for a20 select USERNAME,EXPIRY_DATE,ACCOUNT_STATUS from dba_users where 1=1 and USERNAME like 'ANUJ%'; USERNAME EXPIRY_DATE ACCOUNT_STATUS -------------------- -------------------- -------------------------------- ANUJ Feb-12-2017 03:06:30 OPEN ANUJ1 Feb-13-2017 05:36:06 OPEN <<<<<----