Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> CREATE USER VIA DYNAMIC SQL

CREATE USER VIA DYNAMIC SQL

From: <p_at_eskom.co.za>
Date: Wed, 11 Aug 1999 16:17:29 +0200
Message-ID: <7os0lp$an7$1@nnrp01.ops.uunet.co.za>


Hi,

I have a problem with creating a user through dynamic SQL in a Stored Proc.

I get the error :1301 - Insufficient priviledges, when executing the proc in SQL Plus.

If however, I run the same 'create user' statement in SQL Plus, it works fine.

Both times the proc owner executes the statement.

Can someone PLEASE help?

Pierre Received on Wed Aug 11 1999 - 09:17:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US