怎么修改plsql密码?修改plsql密码方法

sqlplus   /nolog

connect   /as   sysdba

alter   user   sys   identified   by   xxx

  connect as 为：sysdba

 database 为：你自已定义的数据库

 username 为：sys

 password 为：xxx

set serveroutput on;
DECLARE
BEGIN
  FOR c IN (SELECT t.username FROM dba_users t where account_status='OPEN') LOOP
    EXECUTE IMMEDIATE 'alter user ' || c.username || ' identified by ' || c.username ;
    DBMS_LOCK.SLEEP(1) ;
    dbms_output.put_line('user ' || c.username || ' changed ');
  END LOOP;
END;
/