Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> create trigger and create any trigger

create trigger and create any trigger

From: Wiegand, Kurt <Kurt.Wiegand_at_CWUSA.COM>
Date: Mon, 26 Nov 2001 10:11:58 -0800
Message-ID: <F001.003CCF61.20011126100018@fatcity.com>

Is the CREATE ANY TRIGGER privilege required in order for a user to create a trigger on another user's table? Oracle8: The Complete Reference leads me to believe that all the user needs is the ALTER privilege for the table and the CREATE TRIGGER privilege. It seems to say that CREATE ANY TRIGGER is only required if the trigger is to be created in another schema. However, as USER1, I can't get the following to work without it:

CREATE TRIGGER ABC
AFTER INSERT ON USER2.DATA_READY FOR EACH ROW  BEGIN return;
END; SQL> @t3.sql
AFTER INSERT ON USER2.DATA_READY FOR EACH ROW

                           *

ERROR at line 2:
ORA-00942: table or view does not exist

Am I looking at this correctly? (I'm running 8.0.5.2.1 and all privileges on
USER2.DATA_READY have been granted directly to USER1) Thanks.

Kurt Wiegand
IBM Global Services
Cable & Wireless Communications

kurt.wiegand_at_cwusa.com
703 760-3619  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Wiegand, Kurt
  INET: Kurt.Wiegand_at_CWUSA.COM

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: ListGuru_at_fatcity.com (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). Received on Mon Nov 26 2001 - 12:11:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US