I apologize pastorwaris for saying your doctrine was false. Thank you again.
After analyzing the scriptures, I understand what you mean, I think. God has given us what we need to resist. That information is not automatically available to our knowledge. I say that because the Apostles Peter and Barnabas was not aware, or did not use, the information when needed. Paul wrote most of it, but he admits he still struggled with sin.
James 1:14 But each one is tempted when he is drawn away by his own desires and enticed. 15 Then, when desire has conceived, it gives birth to sin; and sin, when it is full-grown, brings forth death. NKJV
First, James stated, most if not all, temptations come from within which seems to be what happened to David. He kept obsessing over her, in his mind, even when she disappeared. His way out-2Samuel 12:8 in addition to his own wives David had been given Saul's wives, and David could have asked God for more, which would have satisfied his desires.
1 Corinthians 10:13 No temptation has overtaken you except such as is common to man; but God is faithful, who will not allow you to be tempted beyond what you are able, but with the temptation will also make the way of escape, that you may be able to bear it. NKJV
Next, God's not allowing us to be tempted beyond our ability is dependent on our taking the way of escape. If we have diligently sought our sanctification and His righteousness we should recognize and use the escape provided. David, and all of us who have sinned repeatedly, have failed because we didn't use the escape plan given to us by God. God's plan of salvation must be used in it's entirety and it takes constant vigilance on our part. Jesus did it all for us, we must use what He has provided.
Romans 7:14 For we know that the law is spiritual, but I am carnal, sold under sin. 15 For what I am doing, I do not understand. For what I will to do, that I do not practice; but what I hate, that I do. 16 If, then, I do what I will not to do, I agree with the law that it is good. 17 But now, it is no longer I who do it, but sin that dwells in me. 18 For I know that in me (that is, in my flesh) nothing good dwells; for to will is present with me, but how to perform what is good I do not find. 19 For the good that I will to do, I do not do; but the evil I will not to do, that I practice. 20 Now if I do what I will not to do, it is no longer I who do it, but sin that dwells in me. NKJV
The final say- as long as we are housed in our flesh, we will never be able to use the tools provided to be without sin. And with the example of David, we should never be confident that sin cannot overcome our resolve to not sin.
Two other items in the gift list. We have the mind of Jesus and the love of Jesus both in the spirit man. While we have His mind and love, they are fighting our carnal mind and carnal love that we have always relied on. While we are in the flesh we cannot ever be without sin.
1 John 2:3 Now by this we know that we know Him, if we keep His commandments. 4 He who says, "I know Him," and does not keep His commandments, is a liar, and the truth is not in him. 5 But whoever keeps His word, truly the love of God is perfected in him. NKJV
If we keep His 2 commandments and His word, we will die in Him and be in heaven. With the flesh dead, along with the carnal mind and carnal love, His mind and love that was in our spirit man is perfected. Our spirit man will now be us thinking like Jesus and our spirit man can love like Jesus loved.