I have a procedure that is executed by an insert trigger that works fine when I am connected as Sys with Sysdba rights when I insert a row of data. When I am connected as a different user I receive the error message ORA-01031: insufficient privileges. I can run the single statement within the procedure through SQL Plus with no problem. Any idea as to what privilege I need to assign other users so that this procedure will execute correctly. The other user is assigned execute any procedure.

create or replace procedure cr8user (cuser IN varchar2, cpass IN varchar2) as

pragma autonomous_transaction;


begin

execute immediate 'create user ' || cuser || ' profile default identified by ' || cpass || ' default tablespace users temporary tablespace temp account unlock';

end cr8user;


This is on Oracle 8i, 8.1.5. Any help would be greatly appreciated.

Thanks,

Greg