the trigger i wrote will prevent all inserts/updates on TableB even if the insert/update is coming directly from the application or as a result of trigger on TableA, if it is initiated by a particular user.

U just wanted the application not to write to TableB, this does just what u need i guess:-)