Whoever you are connecting as has to have CREATE USER privileges.

>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