Change Password in a stored procedure

Hi all,

Is it possible to change a user's password in a procedure?
If yes, how would the code look like?

Also, what is the syntax of using 'execute immediate' in a procedure?

Thanks a lot.

CREATE OR REPLACE PROCEDURE alter_user is
cSQL_statement varchar2(200);

BEGIN
cSQL_statement:= 'ALTER USER SCOTT IDENTIFIED BY SCOTT';

EXECUTE IMMEDIATE cSQL_statement;

End alter_user;


The owner of this proc must have ALTER USER rigth granted explicitely, not only granted the dba role;

Thanks.
But what I should I do if I'd like to catch the password as an input parameter and pass to a variable that replace SCOTT.

Is it like
cSQL_statement:='Alter user scott identified by new_password';

will that do? Thanks.

CREATE OR REPLACE PROCEDURE alter_user
(newpassword VARCHAR2)
IS
cSQL_statement varchar2(200);

BEGIN
cSQL_statement := 'ALTER USER SCOTT IDENTIFIED BY ' || newpassword;

EXECUTE IMMEDIATE cSQL_statement;

END alter_user;

Thanks a lot.