SQL> grant alter any index to mdm3;

Grant succeeded.

SQL>
SQL> exec index_rebuilt('T_OLD_CMPN_HIST_XTRCT');
BEGIN index_rebuilt('T_OLD_CMPN_HIST_XTRCT'); END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "MDM3.INDEX_REBUILT", line 15
ORA-06512: at line 1


SQL>
SQL> grant dba to mdm3;

Grant succeeded.

SQL>
SQL>
SQL> exec index_rebuilt('T_OLD_CMPN_HIST_XTRCT');
BEGIN index_rebuilt('T_OLD_CMPN_HIST_XTRCT'); END;

*
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at "MDM3.INDEX_REBUILT", line 15
ORA-06512: at line 1


SQL>
LINE 15 is
==========================
15 EXECUTE IMMEDIATE 'ALTER INDEX MDM3.' || val || ' REBUILD ONLINE PARALLEL 7 ';
============================

What privilege does it need for execute immediate ????