Does the Manager Field on the User object control Security Access ? For Ex. if I setup User 1 as manager of User 2 then, would User 2 start seeing records owned by User 1 that they could not previously ?
It depends on your other security settings like "Organisation Wide Defaults" for that object as well as the "Grant Access Using Hierarchies" setting. Here you can find a good explanation around how that works.