Re: utl_recomp grants

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

-- 
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net | _at_zztat_oracle | fb.me/zztat | zztat.net/blog/

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