Synonym and Trigger (GRANTS)

Hi,

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:

User: Test
Grants: CONNECT, RESOURCE
Object Privs:
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.

Please help.

Try create any trigger.

Yes, that work out.

But in my production enviornment i am not not allowed to provide the grant to the schema.

Do anyone has some other solution.