Home -> Mailing Lists -> Oracle-L -> utl_recomp grants

utl_recomp grants

From: Suraj ramesh <surajmalliramesh_at_gmail.com>
Date: Tue, 24 Apr 2018 14:35:10 +0530
Message-ID: <CALR=ZhDM-Vh9DWvsoJ1=B05L_nx8WMjD1SVnSf1rhJsy-S5cQg_at_mail.gmail.com> 





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.


--
http://www.freelists.org/webpage/oracle-l


Received on Tue Apr 24 2018 - 11:05:10 CEST












Original text of this message