Synonym and Trigger (GRANTS)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Synonym and Trigger (GRANTS)

  1. #1
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,015

    Re: Synonym and Trigger (GRANTS)

    Try create any trigger.
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2004
    Location
    Mumbai, Maharastra
    Posts
    67
    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
  •  



Click Here to Expand Forum to Full Width