Re: utl_recomp grants

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_at_gmail.com> 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

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