Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: Definers on Triggers

    The developers in my company have done some DB dev and created a number of procedures and triggers which work great, but now I'm ready to move it into a Production environment

    For the procedures, I have changed the security to by the Invoker.. This seems simple so I can manage the permissions by granting specific accounts execute, similar to MSSQL.

    But what do i do for triggers since the only option is to have use a definer. Do I just compile them as root%localhost or should I make a specific user called like TriggerUser which has select/update/delete/insert on all tables? The 2nd option sounds pretty good now that I type it out.

    What are you guys using?

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    A trigger is always linked to a table. So anyone attempting to perform any operation on a table containing triggers will have these automatically invoked. Our policy is to keep these linked with the table owners.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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