Create user
From: Jul <Julia.Sats_at_sympatico.ca>
Date: Mon, 23 Sep 2002 22:00:37 -0400
Message-ID: <TKPj9.1927$wj3.351106_at_news20.bellglobal.com>
Date: Mon, 23 Sep 2002 22:00:37 -0400
Message-ID: <TKPj9.1927$wj3.351106_at_news20.bellglobal.com>
PROCEDURE a_add_user IS
END;
ORA-01031: insufficient privileges
Procedure was created and run by user with DBA privileges
I can not run this code under Oracle 8.0 . Any ideas ?
v_str varchar2(100);
n_cursor number;
BEGIN
n_cursor := dbms_sql.open_cursor;
v_str := 'create user M identified by M';
dbms_sql.parse(n_cursor, v_str, dbms_sql.native); <== ERROR HERE
dbms_sql.close_cursor(n_cursor);
Thanks Received on Tue Sep 24 2002 - 04:00:37 CEST