Stop! Or My Mom Will Shoot - 1992

A tough cop's (Sylvester Stallone) apparently delicate mother (Estelle Getty) comes to stay with him progressively interferes in his entire own life. She buys him a prohibited MAC-10 machine pistol and starts poking around within his police cases. Eventually, the film brings to a denouement involving the name of the picture and also the revelation that despite the fact that she seems frail and weak she's capable of strong actions in some conditions, i.e. once her kid is jeopardized by thugs and she shoots herself in the shoulder.