PRIVILEGE PROBLEMS USING EXECUTE IMMEDIATE!

Can anyone help me.

I have a table in SCHEMA1:=

create table TESTTAB (Dummy varchar2(10) ); grant alter,insert, update, delete, select ON TESTTAB to SCHEMA2

Within SCHEMA2 I can do:-
truncate table SCHEMA1.TESTTAB;

But The following aborts with a Insufficient privileges:-

create procedure DoIt IS
BEGIN
   execute immediate 'TRUNCATE TABLE SCHEMA1.TESTTAB'; END; BEGIN
   DoIt;
END; There must be some additional privileges needed to use execute immediate across Schema's. (these all work if all objects are in the same Schema!

TIA Received on Mon Nov 28 2005 - 13:01:29 CST