Post reply

Trigger Execution

  • February 21, 2003 at 8:17 am

    #175316

    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

  • February 24, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • February 24, 2003 at 9:46 am

    #449586

    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.

  • February 24, 2003 at 9:53 am

    #449588

    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