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] subscribe: send a blank email to oracledba-[Email Address Removed] 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