| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: create trigger and create any trigger
hI....
You must have "create any trigger" privilege to create trigger on any table which in other schema. The "alter any table" will allow you to change the structure of table, but not to create trigger on it.
-----Original Message-----
From: Wiegand, Kurt [SMTP:Kurt.Wiegand_at_CWUSA.COM] Sent: Monday, November 26, 2001 9:00 PM To: Multiple recipients of list ORACLE-LSubject: create trigger and create any trigger
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, KurtReceived on Tue Nov 27 2001 - 01:14:58 CST
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).
 |
 |