Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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
*
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
![]() |
![]() |