Synonym and Trigger (GRANTS)
I am creating a trigger on a synonym which is a table in some other schema. I am not able to create the trigger it says Insufficient Privileges.
Following is the scenario:
Grants: CONNECT, RESOURCE
Table: Test1.EmpDetails (Grants: DELETE, INSERT, SELECT, UPDATE).
Created a synonym of EmpDetails of Test1 schema and when i am trying to create a trigger on the same from Test schema on the synonym it prompts a error stating "ORA-01031: insufficient privilege".
The above works if i grant DBA role to the schema TEST.
I preassume the problem is with the roles that has been provided. But, i am not sure which role to be provided.
Surajit K Mitra
Click Here to Expand Forum to Full Width