执行SQL得到重置oracle用户密码的命令:
select 'alter user '||name||' identified by values '''||password||''''||';' from (select name,password from user$ where name in (select username from dba_users where account_status='EXPIRED'));
执行alter user命令问题解决。
执行SQL得到重置oracle用户密码的命令:
select 'alter user '||name||' identified by values '''||password||''''||';' from (select name,password from user$ where name in (select username from dba_users where account_status='EXPIRED'));
执行alter user命令问题解决。