creating users in stored procedures

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

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

• uprawnienia w bazie execute immediate 'grant connect,unlimited tablespace to '||vloginname;
• rejestracja w spacer_users MY_APPLICATION_SPECIFIC_COMMANDS end;

In 9i this no longer works. Oracle reports access rights error. It happens even when both the procedure owner and caller are SYS.

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

Regards,

        Marcin Received on Fri Jan 18 2002 - 04:57:42 CST