ORACLE 10g、11g批量刷新用户密码

数据运维 2024-06-30 贤蛋大眼萌 手机阅读

一、ORACLE 10g批量刷新用户密码

select 'alter user ' || username ||' identified by values '''||password ||''';' from dba_users where ACCOUNT_STATUS'LOCK' and ACCOUNT_STATUS not like 'EXPIRED%LOCKED';