I have a trigger that runs after a record is added to a table. This trigger is owned by <font color=blue>dbo</font color=blue>. It uses the extended stored proceedure <font color=blue>xp_sendmail</font color=blue>.
I have granted Seelct and Insert permissions on the table to the user DatabaseUsers (from the DatabaseUsers Login).
My problem is that when a user who is a member of this login and consequently this database user executes the trigger by adding a record to the table, SQL Server reports that they don't have permissions to run the <font color=blue>xp_sendmail</font color=blue> stored proceedure.
I thought that the trigger runs in the security context of it's owner (which in this case is dbo), so the trigger should also have permission to use the xp_sendmail stored proceedure.
Can anyone spread any light on this?