Home » SQL & PL/SQL » SQL & PL/SQL » trigger - one user to another user
trigger - one user to another user [message #204841] Wed, 22 November 2006 06:08 Go to next message
mudalimuthu
Messages: 64
Registered: May 2005
Location: Bangalore
Member
create or replace trigger mytrig
before insert or delete on scott.temp111
for each row
begin
if inserting then
update mfgdemo.temp111 set mychar = '123';
end if;
end;



i want to update/insert from one user to another user's table
when i wrote the above code, i am getting the following error message.
insufficient privileges

can someone send the correct code

regards
muthu
Re: trigger - one user to another user [message #204843 is a reply to message #204841] Wed, 22 November 2006 06:23 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
CREATE ANY TRIGGER
This system privilege allows you to create a trigger in any user's schema on a table in any user's schema.

also you need to have UPDATE privilege on the table temp111.

By
Vamsi
Previous Topic: How many 'a' we have before 's'
Next Topic: Urgent: Need to find parent child relationships between table
Goto Forum:
  


Current Time: Mon Dec 05 21:21:13 CST 2016

Total time taken to generate the page: 0.05267 seconds