It;s just a privilege matter.
I gave the DBA privilege to the user A but nothing happend.
Then, i gave the create user grant to the user A and the problem solved.



----- Original Message -----
From: "anu" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Saturday, November 29, 2003 1:32 AM
Subject: Re: ORA-01031 and ORA-06512


> Hi,
> I think if the owner of the procedure has the privilege then it is
enough. So
>
> 1) User A creates a stored procedure SP_X.
> 2) User A gives execute privilege on SP_X to user B.
>
> Then user B need not have the privilege. USer A has to have the privilege
to do things in the procedure SP_X.
>
> Siva <[Email Address Removed] wrote:
> The user who executes that statement has to have direct permission granted
> to execute that ddl statement. In this case, the user has to have
permission
> granted directly to create user.
>
> ----- Original Message -----
> From: "John"
> To: "LazyDBA.com Discussion"
> Sent: Friday, November 28, 2003 1:46 PM
> Subject: ORA-01031 and ORA-06512
>
>
> I have the following errors when i try to create a user via a procedure
>
> ORA-01031: insufficient privileges
> ORA-06512: at "SYS.DBMS_SYS_SQL", line 826
> ORA-06512: at "SYS.DBMS_SQL", line 32
> ORA-06512: at "TOM.P_NEW_USER", line 6
> ORA-06512: at line 1
>
>
> The line 6 points to DBMS_SQL.PARSE()
>
>
> Do you know how to solve it?
>
> I use Oracle 9i R2
>
>
> --------
> Get today's cartoon: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: send a blank email to oracledba-[Email Address Removed] To subscribe: send a blank email to oracledba-[Email Address Removed] By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
> ---------------------------------
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now


Oracle LazyDBA home page