For a body of mass m moving in a horizontal circle on a wall of death, the normal reaction from the wall is what supplies the force necessary to obtain motion in a circle.
So we can write: N = mv2/r
If the body does not slide down the wall, then the pull of gravity downwards must be balanced by the frictional force (due to the �roughness' of the wall) upwards.