Re: Oracle Password-Changing Script

any user can alter their own password via sqlplus. however, if you mean in the context of some app where you put out a little screen for user and then do the change, you will need to use dynamic sql to do the sql statement. an example procedure is:

     procedure alterpw(user_i in varchar2, pw_i in varchar2) is
        cur integer;
        str varchar2(80);
        ret integer;
     begin
        str:='alter user '||user_i||' identified by '||pw_i;
        cur:=dbms_sql.open_cursor;
        dbms_sql.parse(cur,str,dbms_sql.v7);
        ret:=dbms_sql.execute(cur);
        dbms_sql.close_cursor(cur);
     end;

-- 
Thomas Dunbar    540 231-3938    http://gserver.grads.vt.edu/