Oracle Database Discussions

Hi,

I am able to create a table through anonymous PlSQL block or through command line, but when I try to do the same with a stored procedure with dynamic SQL it says "insufficient Priv".
When I enable AuthID Current_User in my Procedure Or I provide the grant "Create Table" explicitly to the User, I am able to create the Table through same procedure.

Can someone tell me Why Its happening, When the same user is able to create the table from SQL prompt and Anonymous Block but can't perform thew same from Stored Procedure? Where the roles are conflicting or where the Invoke/Definer Rights are violating?

Thanks in Advance