
- Forum
- Programming Talk
- Oracle JDeveloper
- how to access other schema synonym inside a trigger
how to access other schema synonym inside a trigger
This is a discussion on how to access other schema synonym inside a trigger within the Oracle JDeveloper forums, part of the Programming Talk category; I created two schemas:-RMS, STG Two roles:-rmsintg, stgintg rmsintg is associated to RMS stgintg is associated to STG stg> I ...
-
how to access other schema synonym inside a trigger
I created two schemas:-RMS, STG
Two roles:-rmsintg, stgintg
rmsintg is associated to RMS
stgintg is associated to STG
stg> I created a table S1
stg> Insert, Update, Delete, Select privileges on this (S1) table are granted to rmsintg(RMS user) role.
stg> created a public synonym for S1.
Rms>in this user I created a trigger s1_aiudr_tr
In this trigger there is insert statement
Insert into S1(…..so on)
Here I am getting error “INSuffient privileges”
I’m able to insert into S1 in sql window. But inside a trigger it is firing that error. Could you help me out of this problem.
-
I created two schemas:-RMS, STG
Two roles:-rmsintg, stgintg
rmsintg is associated to RMS
stgintg is associated to STG
stg> I created a table S1
stg> Insert, Update, Delete, Select privileges on this (S1) table are granted to rmsintg(RMS user) role.
stg> created a public synonym for S1.
Rms>in this user I created a trigger s1_aiudr_tr
In this trigger there is insert statement
Insert into S1(…..so on)
Here I am getting error “INSuffient privileges”
I’m able to insert into S1 in sql window. But inside a trigger it is firing that error. Could you help me out of this problem.
thanks and regards
ml varma

Reply With Quote






