Trigger Execution

  • When a trigger fires what user/role is used for security? We have a trigger that fires and queries another database on the same server but the developer are getting select denied error. The developer can query the table in query analyzer.

    Thanks

  • This was removed by the editor as SPAM

  • According to BOL...

    CREATE TRIGGER permissions default to the table owner on which the trigger is defined, the sysadmin fixed server role, and members of the db_owner and db_ddladmin fixed database roles, and are not transferable.

  • Thanks for the reply

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply