compile_schema

From: <bmennell_at_bftl.com>
Date: Thu, 30 Jul 1998 19:33:58 GMT
Message-ID: <6pqhr6$ne3$1@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 - 14:33:58 CDT