When you put a player on connect method, does it hold?

Depends on the event, the PlayerAdded event will hold the player until he leaves, the CharacterAdded will hold the Character until it is removed (the player dies or is respawned). The touched event will hold the part for as long as you want, but I assume you are referring to the PlayerAdded command which fires once when the player joins and is used mainly for setting up the player (leaderstats, chatted events, character added and removing events).

To add onto crackabottle's answer, if you want a connection to no longer apply to an object, you can disconnect it. The connect method returns a RbxScriptConnection that contains a disconnect method. For example-

local connection 
connection = Part.Touched:connect(function(hit)
    print("Touched")
    if hit.Parent.Name == "Player1" then -- if a character with the name of Player1 hits it, then
        connection:disconnect() -- disconnect the connection, meaning "Touched" won't be printed anymore when the Part is touched
    end
end)