Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    24

    Unanswered: creating trigger

    Hi,

    I have an acount which can perform any DML activity to another user object. If I create a after insert trigger of the another user table in the current schema I am facing Insufficient privilage. I am using username.objectname. My oracle version is 9i and os is windows 2000

    Can any body tell we what is the issue?

    Thanks in advance.

    -Mohit.

  2. #2
    Join Date
    Dec 2003
    Location
    SLOVAKIA
    Posts
    10

    Re: creating trigger

    Do you have ... "CREATE ANY TRIGGER" privileges?

  3. #3
    Join Date
    Dec 2003
    Posts
    24
    Yes a user have create any trigger privilages..

  4. #4
    Join Date
    Dec 2003
    Posts
    74
    as far as I know you cannot create a trigger on a table unless you are the owner of the table.

    I am almost certain that the trigger code needs to reside in the same schema as the data.

    Can you modify the table from the other schema?

    if not ensure that the user has the priviledge to alter the table.

    grant alter on table to user

    hope this is of some help

  5. #5
    Join Date
    Nov 2003
    Location
    down on the cube farm, left then right then another left
    Posts
    467
    I am not certain that "create any DML" (data manipulation language i.e. inserts, updates, etc) includes "create any trigger" which I believe is DDL. Try explicitly granting "create any trigger"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •