I can't see very well from your photo, but the norm would be for the screw to hold a bush (a silver bit) that runs in the connecting rod bearing (a brassy bit).
This screw should be tight to hold the bush and enable it to turn within the rod bearing.
To be sure, if you could undo the crank screw and do a closeup photo of the crank rod would help to see.