Re: compile_schema

You possibly need create/alter any schema privileges

Regards !!!

Oracleguru

bmennell_at_bftl.com wrote in article <6pqhr6$ne3$1_at_nnrp1.dejanews.com>...
> We get this error running: DBMS_UTILITY.compile_schema('DEV1')
>
>
> ERROR at line 1:
> ORA-20000: You have insufficient privileges for an object in this schema.
> ORA-06512: at "SYS.DBMS_UTILITY", line 219
> ORA-06512: at line 1
>
>
> We 've tried to add the ALTER ANY PROCEDURE (system priv)
> and EXECUTE ON SYS.DBMS_UTILITY (object priv ).
>
> What do we need to do to fix the permissioning ?
>
>
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
Received on Thu Jul 30 1998 - 16:03:08 CDT