Exforsys
+ Reply to Thread
Results 1 to 2 of 2

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 ...

  1. #1
    mlvarma is offline Junior Member Array
    Join Date
    Mar 2008
    Answers
    2

    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.


  2. #2
    mlvarma is offline Junior Member Array
    Join Date
    Mar 2008
    Answers
    2
    Quote Originally Posted by mlvarma View Post
    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


Latest Article

Network Security Risk Assessment and Measurement

Read More...