how to access other schema synonym inside a trigger

[mlvarma]

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.

[mlvarma]

Originally Posted by mlvarma

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

[Flowermyface]

this place is neat i have some friends on this site and they said nobody will pick on me here im quiet and listen. i joined elsewhere and they told me i was a newbie and posted in the wrong area sorry guys i am learning. be nice to me and im sure i can help you somehow thank you

im slowing understanding i never had internet my whole life because my dad was against computers now that im out of the house HAH he cant stop me now