Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2006
    Location
    ISTANBUL/TURKEY
    Posts
    6

    Unanswered: Cannot See Triggers Via Role

    Hi,
    I created a role named KKM_USER_ROLE and add users to that role. But users cannot see other users' triggers. How can i make somebody in that role to see triggers.
    thnaks.

    Koray

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Do you mean see the source code of other users' triggers? I can't check right now but if it isn't CREATE ANY TRIGGER/DEBUG ANY TRIGGER system privilege, it will be CREATE ANY PROCEDURE/DEBUG ANY PROCEDURE. I suppose the DEBUG ANY grants are less insecure.

  3. #3
    Join Date
    Feb 2006
    Location
    ISTANBUL/TURKEY
    Posts
    6
    Hi WilliamR;
    Thanks for your help,
    Although i tried earlier, this time system privilige CREATE ANT TRIGGER has solved the problem. Thanks for your help.

    ISBDBA

  4. #4
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Please be aware that you have just given the two schema users the ability to create a trigger on ANY table in the database. This is a VERY bad idea.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

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