GRANT INSERT ON dbo.DBSchema_Change_Log TO PUBLIC
GRANT CONNECT TO guest
This is the easiest way. I am , in general, not a fan of granting rights to public, but in this case, this is probably OK. I enable guest, and then anyone maps over to guest and data is inserted.
Hi Steve. This article suggests that SELECT is required, in additional to INSERT, on the log table. Can't see why, though.