Originally posted by oracle_faq
The scenario I am trying to solve is as below.

1. Create a table in a procedure.
2. Grant insert update select delete on the table...within the same procedure.

Since I am creating the table in a different schema that the user who is executing the procedure...the procedure execution fails. So was looking for a privilege I need to give to the user to make it work. This user already has DBA privs. The only problem is that PL/SQL does not see these privs...so I have to grant them explicitly.
This privilege Should work.
Code:
GRANT create any table TO schema_owner;
It is probably best if you give out privileges that user need and no more.