Specific Priv to allow "Alter view ... compile> in a PL/SQL procedure

11.2.0,4 (Yes I know :-) )

What specific grant do I need?

Already has CREATE any VIEW

DROP any VIEW

CREATE any TABLE

DROP any TABLE

Procedure Code needs to be able to alter view compile IN ANOTHER SCHEMA

E.g. Simple example Below.

create or replace PROCEDURE PROC_CRM_DEPENDENCY_RECOMPILE

AS

Begin

 DBMS_OUTPUT.PUT_LINE('1');

 execute immediate('ALTER VIEW ODS_CRM.V_PAH_TEST COMPILE');

 DBMS_OUTPUT.PUT_LINE('2');

 execute immediate('ALTER VIEW ODS_CRM.V_O_CLARIFY_TABLE_ACT_VIEW COMPILE');

 DBMS_OUTPUT.PUT_LINE('3');

end;

/

SQL> exec PROC_CRM_DEPENDENCY_RECOMPILE;