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:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 9:00 PM
To: Multiple recipients of list ORACLE-L
Subject: 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
[EMAIL PROTECTED]
703 760-3619
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Wiegand, Kurt
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).
