An alternative would be to use dbms_utility.compile_schema which has no
such restriction:
https://docs.oracle.com/database/121/ARPLS/d_util.htm#ARPLS73226
On Wed, Apr 25, 2018 at 3:01 PM, Niall Litchfield <
niall.litchfield@xxxxxxxxx> wrote:
Can I ask what the objective is here? The documentation is pretty clear as
to the intended use, and the requirement to be connected AS SYSDBA.
https://docs.oracle.com/database/121/ARPLS/u_recomp.htm#ARPLS71434
On Tue, Apr 24, 2018 at 10:05 AM, Suraj ramesh <surajmalliramesh@xxxxxxxxx
wrote:
Hello,
DB Version: 12.1.0.2
I am looking whether its possible to run EXECUTE
UTL_RECOMP.RECOMP_PARALLEL() command by any other DB user apart from Sys.
I have tried the below and ended up with error.
grant execute on sys.UTL_RECOMP to TEST;
Connect test/test
EXECUTE UTL_RECOMP.RECOMP_PARALLEL(4);
BEGIN UTL_RECOMP.RECOMP_PARALLEL(4); END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'UTL_RECOMP.RECOMP_PARALLEL' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Regards
Suraj.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info