creating users in oracle9i stored procedure

I am sorry for posting this the second time. The only answer I got is that there is a kind of grant problem It did not give me so much

In previous to 9i releases of database
I used stored procedures to register user accounts. It looks like

create procedure (....)
as begin
  execute immediate 'create user '||vloginname||' identified by
'change_it' ;

  execute immediate 'grant connect,unlimited tablespace to
'||vloginname;

  MY_APPLICATION_SPECIFIC_COMMANDS
end;

In 9i this no longer works. Oracle reports access rights error.

ORA-01031: niewystarczaj?ce uprawnienia
ORA-06512: przy "PROMO.ADD_PROMO_USER", linia 11

It happens even when both the procedure owner (that has DBA granted) and caller are SYS.

The question is: How to create user in stored procedure in Oracle9iNTEE ?

Regards,

        Marcin Received on Mon Jan 21 2002 - 03:21:48 CST