-
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.
Regards,
Surajit K Mitra
-
Re: Synonym and Trigger (GRANTS)
-
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.
Regards,
Surajit K Mitra
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|