[Q] Problem with public access procedure

Hi there,

I try to write up a public function to let people use it to change their passwd easier, as this:

create or replace procedure passwd (pwd varchar2) as

	c1 integer;
	x char(8);
begin
	c1:= dbms_sql.open_cursor;
	dbms_sql.parse(c3, 'ALTER USER ' || user || ' IDENTIFIED BY ' || pwd, dbms_sql.v7);

After I grant to public, and start it, I get permission denied. It seems it can't execute the system function "user" which returns the user name. Any idea how to solve it?

Email or post news will be fine. Thx.

Wilson.

--
Tang Wai Shing, Wilson				email: cswstang_at_cs.ust.hk
Department of Computer Science, HKUST, HK	tel# : (852)-358-7004

	** Not trying to be the best among yourselves... **
 	** but  ALWAYS BE THE BEST WITHIN YOURSELF!  :)  **