Alex Lima

How to avoid resetting expired passwords in Oracle


SQL> col username format a30
SQL> select username , account_status from dba_users where username = 'DBSNMP';
USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP EXPIRED & LOCKED
SQL> alter user DBSNMP account unlock;
User altered.
SQL> select username , account_status from dba_users where username = 'DBSNMP';
USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP EXPIRED
SQL> set linesize 300
SQL> select 'ALTER USER '|| USERNAME || ' identified by values ''' || spare4 || ''';' from dba_users,user$
2 where ACCOUNT_STATUS like '%EXPIRED%' and USERNAME=NAME;
'ALTERUSER'||USERNAME||'IDENTIFIEDBYVALUES''||SPARE4||'';'
————————————————————————————————————————————————————————————————————————————————————————————————————
ALTER USER GSMCATUSER identified by values 'S:BC49C4364BD9BE00C40CB2F62B61BCBF985F28CC93596E14F69905C3F78E;T:D1A4D7188DCFAA0241DAFED27B80EBA391574FEB2C1A1DD762DB1FCD283FF263A0225977AF2A160158BB7CF756C2C0C3C493E942B61D276DE52D45D48ED847738F69311336A0201AF167B6CE9C567D96';
ALTER USER SYSBACKUP identified by values 'S:126F6019C997D530A89DEF92C2252A2FED8A1DA3DE10A2E52073A6707C8C;T:C626C63A6861F46FC9238CA5DCD41EC41DA92BABE48D1252EB001C1CC4DC12BE160EDEFDD9A1BFCABCD3AA90B82BA436AC766A64696A8A51424C3D40F6BE70C96D41A5E532E786370AE8E4E53A506FC0';
ALTER USER DIP identified by values 'S:CE9385C903B88E7CC41EF6186A235C1D399DDE5622746A432B18796D015E;T:3A6E30FEB27E2483ABED2ACCF4CE36380E726A181D7CAD2EA972515DFB474DB343C9CECD4E143478A76FB85256DEB9D7A780B6084A3939A3E67A72B1F35D1A485B8260A1B2A2F12B7D2B6E2BB9346931';
ALTER USER SYSDG identified by values 'S:CF44D6A586AB4E469A6226C51FCD726E5E80E7B7153176E8BECDD96EA0CC;T:9BE97FB9BA5FA1EABCBA7A6A4AF3A3BA1485FCD305354B1D207FD971B387DBD34DC2E5025998BC4B6E4F9ED78B5F1CF63D74E02E76209EF3A5DCE3D18F05A8E4CCB042354A39A72514B081C38C0277A0';
ALTER USER ORACLE_OCM identified by values 'S:79170374A3FD651DAFEC79665A19AA4C038FE712BA98290827709585353F;T:B871B7CF1E35E5EB9814F5F2C7B198BFA4B39A7327F0F514E793D97A358866744808E589F671DB44717A81EABC62D648FB8305919E721C4E0309D03457ABA84EA98D05595CB90EC42C54C09416EA339E';
ALTER USER SYSKM identified by values 'S:6C9369A4774256F132538D72C75EBE23E8530E8C2D1A3AB43BF52A3ACF02;T:C9AC862B1D776B37B41E59FA4224EC0B499FFB50A027E8345763F5E970B4BC359EA20EF7CB276C250124C4D2C12B551715B97F729CE715D8B0664421891C526E5520461C9676F841B74E27720F377021';
ALTER USER XS$NULL identified by values 'S:000000000000000000000000000000000000000000000000000000000000';
ALTER USER GSMUSER identified by values 'S:4DFAC1E129481B6DD6F920AE417B7E45705F1A2397914705456B84EF6C12;T:F30D01574678D40905D91E012918F532BC00DF45C01DD14A904DDD3F9B292F220079C7E906BE6AD2D967FC79B998344B3CD2B319263D47E4E40B38B9AA4564B2F02EB8D77547B53BCA255C37D62A2276';
ALTER USER AUDSYS identified by values 'S:EB56F8A43E73191319E55B9C1A1817F3BD8CF2F193667FF98C761FBD4F21;T:EBAF9BFC8675B3C6B2FC57ECE94295D9665C3B52D624D8FF9D579F27B0BF3043EDCE53F1420D541B569C57A71380008196266F501088FD433D75CB9EEC77289BA103079E5F14228C6FE2EE4CED671CA5';
ALTER USER ANONYMOUS identified by values ';
ALTER USER DBSNMP identified by values 'S:383992A80DFF649B51C8101D60B740F591AECEFBD7EA3AC1A0376F935685;T:FEE0A49CF73F44E3E7ED27C3B6CE7BCA1BA968D5E2A97A7C4E26616CDEF7E99F0B742FAB066CE9B6CF402C5097D2D81B8D8A6B4FFE3BBEB5C1AEE72DC307CF4C6253EC756E5DCA661B3526ADE22D4EBC';
'ALTERUSER'||USERNAME||'IDENTIFIEDBYVALUES''||SPARE4||'';'
————————————————————————————————————————————————————————————————————————————————————————————————————
ALTER USER WMSYS identified by values 'S:C250DE38E0BEC715261050CC59B8254729C95C2EB06EF8AFD6A2D7DFF31D;T:9B3586C170F3755DCDF345ECD106D54B8AAA08E749E6BEACE8E5C3571D51A132C0FC2C0CC2B24F82F41AB41CF3C199C78381816907E462F84E09D25AD10008DE548AB2FE4703481D52EBE210C771BF41';
ALTER USER XDB identified by values 'S:C5F0E806FD04CAA1525BD36EC178AAA3A3523FED574C9F12422CDBBDD37E;T:49C85D819CA83AF5764DFFCAE2E9047F89B268628831A75F4C33E57CF573380A75B7773E9F73F1D7AA20A281C4BBF1DAAC896C58DE88EF2D50E74F4C950D2068525CD6710BA4784EB0E93C8FC76F5200';
ALTER USER APPQOSSYS identified by values 'S:F5416AE447504E7ED74161C5BBAFE2E1FCAA2FF735C8182AE29E63601EE5;T:E71ACD9F7B89E3938E9E0777EB1A5675E2578DC0FC3BE3F464FCEA3632A2F2DA5AC75634DB1998A0C89083D9490C07AF2C507AA13324CAE1016AB411D6613D8F86A9A570D4A5D59C76AFFF3148CD5905';
ALTER USER GSMADMIN_INTERNAL identified by values 'S:4711F6A34D4155E4B7E819E20BCB8F4017FD0513FE90F9540365BD3AF027;T:6569E0EA09DEF13523E4D0706A635E0C78EC480B88FC523C543EBA0353D1958B14F0322EE4149F5C4D40642D236FE9F2A5429713E4A735FCD0A812F7E1A4A044A1FECF5418778F5280653E0953F91E9D';
ALTER USER OUTLN identified by values 'S:137EA0571CC4E4D58462AC335CA93DB25EF655A31D45B9B70726F8A6857A;T:C8C8FE0C0A94DBD4C24A4B8FE96F4BCBE8D34CC93A9EC4253C1A42B95F0C5E551D65E38FA374C01D1DC62CDB5A452EC8AAB64770CB7519E5DA19933ADB4A84527942A4C362B3BBB0DF01908ABE71BE81';
16 rows selected.
SQL> ALTER USER DBSNMP identified by values 'S:383992A80DFF649B51C8101D60B740F591AECEFBD7EA3AC1A0376F935685;T:FEE0A49CF73F44E3E7ED27C3B6CE7BCA1BA968D5E2A97A7C4E26616CDEF7E99F0B742FAB066CE9B6CF402C5097D2D81B8D8A6B4FFE3BBEB5C1AEE72DC307CF4C6253EC756E5DCA661B3526ADE22D4EBC';
User altered.
SQL> select username , account_status from dba_users where username = 'DBSNMP';
USERNAME ACCOUNT_STATUS
—————————— ——————————–
DBSNMP OPEN

view raw

gistfile1.txt

hosted with ❤ by GitHub

Leave a Reply

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

Gravatar
WordPress.com Logo

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

Facebook photo

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

Cancel

Connecting to %s

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