Oracle V7.3.4.3 on V2.6 Solaris
For all practical purposes "MWH" owns all objects in this application.
AFAIK The object does exist as shown below and as the owner and with
CREATE ANY PROCEDURE priv MWH should be able to compile it.
So why do I keep getting these ORA-20000 errors?????????????????????
SQL> exec dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER',user,'CDH_AFT_UPD_ROW'); end;
*
ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1
SQL> sho user
user is "MWH"
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;
*
ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1
SQL> select * from user_objects where object_name = 'CDH_AFT_UPD_ROW';
#:-)
OBJECT_NAME
--------------------------------------------------------------------------------
OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
---------- ------------- --------- ---------
TIMESTAMP
---------------------------------------------------------------------------
STATUS
-------
CDH_AFT_UPD_ROW
49325 TRIGGER 14-MAR-99 01-MAR-01
2001-03-01:10:19:34
VALID
SQL> connect sys/pass
Connected.
SQL> grant execute on dbms_ddl to MWH;
Grant succeeded.
SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;
*
ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1
SQL> connect sys/pass
Connected.
SQL> grant create any procedure to MWH;
Grant succeeded.
SQL> connect mwh/pass
Connected.
SQL> exec dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW');
begin dbms_ddl.alter_compile('TRIGGER','MWH','CDH_AFT_UPD_ROW'); end;
*
ERROR at line 1:
ORA-20000: Unable to compile TRIGGER "MWH"."CDH_AFT_UPD_ROW", insufficient
privileges or does not exist
ORA-06512: at "SYS.DBMS_DDL", line 47
ORA-06512: at line 1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
