I am using Oracle 8.0.3.0

I have 2 users scott and tom

both are having the same emp table.

I created a trigger on scott.emp for auditing and wants to update tom emp table simultanously.

So i tried to write

if inserting then
delete from tom.emp where emp_code =:new.emp_code;
insert into tom.emp (select * from ...);
end if;

User tom is not accepting?

Cam you kindly give the way.

The user is having every right to do that. I tried in sql it is working


gln

It should work OK. What error are you getting?

Hi,
As Andrewst suggested, the error is needed to identify the
problem. But assuming that you are getting " table or view
does not exist error".
All you have to do is login to tom and give access to the emp table
to scott.

SQL>connect tom/password@db_name

SQL> grant all on emp to scott;

Hope it Helps.