If your application is using a distinct user id, the u can write an INSTEAD OF trigger on table b and check if the user_id is same as application's. if this condition satisfies, insert/update can be prevented.

create trigger trg_stock on test instead of insert, update

as

if SYSTEM_USER ='sa'

print 'not inserted/updated'