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.
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.