Midrash sa Mga Awit 119:79: Ein Yaakov (Glick Edition) & Bamidbar Rabbah

R. Huna said: "How little does he whom the Lord supports, need to grieve or trouble himself. Saul committed only one sin and was discharged from royalty. David committed two sins, and yet retained it." "Saul committed only one sin." What was it? That of Agag. But did he not commit another sin when he massacred the priests of Nob? Nevertheless only at the incident of Agag it is written (I Sam. 15, 11) I regret that I have set tip Saul as a king. "David committed two sins." What are they? That of Uriah and his numbering of Israel. But there is a third one? That of Bath Sheba? For Bath Sheba he was punished, as it is written (II Sam. 12, 6) For the ewe he shall pay fourfold. What were the four punishments? The death of Bath-Sheba's first child, the death of Amnon, the misfortune of Tamar, and of Absalom. If so, then, was he punished also for numbering Israel? As it is written (II Sam. 24, 15) And the Lord sent a pestilence in Israel from the morning even to the time appointed. In that case he himself was not punished, but in the instances we mentioned, he was personally punished, as R. Juda said in the name of Rab: "For six months David became leprous, and the Sanhedrin separated themselves from him, and the Shechina departed from him, as it is said (Ts. 119, 79) Let those that fear Thee return unto me, and those that knew Thy testimonies, and it is written again (Ib. 51, 14) Restore unto me the gladness of Thy salvation." But has not Rab said that David listened to slander? [Hence he committed more sins?] The former statement is in accordance with the opinion of Samuel who holds that David did not listen to slander. And Rab who holds that David did listen, explains that David had also been punished for it; for R. Juda said in the name of Rab: "At the time when David said unto Mephibosheth (II Sam. 19, 30), Thou and Ziba shall divide the field, a Bath-Kol went forth and said, 'Rechabam and Jeroboam will divide thy Kingdom.' "

Another matter: “Bring the tribe of Levi near…” (Numbers 3:6) – that is what is written: “Happy is one You choose and bring near” (Psalms 65:5). Happy is the man whom the Holy One blessed be He has chosen even if He did not bring him near, and happy is the man whom the Holy One blessed be He brought near, even if He did not choose him. Who is the one whom He chose? It is Abraham, as it is stated: “You are the Lord God, who chose Abram” (Nehemiah 9:7); but you did not bring him near, but rather, he brought himself near. Jacob, the Holy One blessed be He chose him, as it is stated: “For the Lord has chosen Jacob for Himself” (Psalms 135:4), and likewise it says: “Jacob whom I have chosen” (Isaiah 41:8); but you did not bring him near, but rather, he brought himself near, as it is stated: “Jacob was a wholesome man who resided in tents.” (Genesis 25:27).¹¹Bereshit Rabba 63:10 states that the word “tents” is referring to the study halls of Shem and Ever, in which Jacob studied Torah. Moses, He chose him, as it is stated: “Were it not for Moses, His chosen” (Psalms 106:23), but He did not bring him near. Happy are those whom the Holy One blessed be He chose even though He did not bring them near.
Come and see Yitro;¹²Shemot Rabba 27:2. the Holy One blessed be He brought him near but did not choose him. Raḥav¹³Ruth Rabba 2:1. the prostitute, He brought her near but did not choose her. Happy are those whom He brought near even though He did not choose them.
A noblewoman asked Rabbi Yosei; she said to him: Does Your God bring near anyone He wants? He brought a basket of figs before her, and she was selecting carefully and selecting and eating. He said to her: Do you know how to select and the Holy One blessed be He does not know how to select? One whom He sees that his deeds are good, He chooses him and brings him near.
Rabbi Neḥemya in the name of Rabbi Shmuel bar Rav Yitzḥak: Not everyone who is near remains near, and neither does everyone who is distant remain distant. There are those who are chosen, rejected, and brought near. There are those who are chosen, rejected, and not brought near. Aaron was chosen: “And chose it from all the tribes of Israel to be priests for Me” (I Samuel 2:28). He was rejected: “The Lord was incensed with Aaron” (Deuteronomy 9:20). And it is written: “And you, bring Aaron your brother near to you” (Exodus 28:1).
Saul was chosen: “Have you seen that the Lord has chosen him” (I Samuel 10:24). He was rejected: “I have regretted that I crowned Saul…” (I Samuel 15:11). But he was not brought near: “I have spurned him from reigning over Israel” (I Samuel 16:1).
David was chosen: “He chose David His servant” (Psalms 78:70). He was rejected: “The king set out with his entire household in his wake.… [The king set out,] and all the people in his wake, and they stopped at a remote house” (II Samuel 15:16–17). Rabbi Yehoshua ben Levi said: They ostracized him; nevertheless, he accepted his ostracization; that is what is written: “David ascended the ascent of the Mount of Olives, weeping as he ascended, and his head was covered [and he walked barefoot]” (II Samuel 15:30). And he was brought near; Rabbi Yudan said: Ira the Ya’irite, David’s teacher, brought him near. That is what David says: “May those who fear You and who know [yodei] Your precepts turn to me.” (Psalms 119:79). It is written: Who know him [yodo];¹⁴Although the verse is read in the plural – those who know – the word know is written in the singular, thus implying that it is referring to a single individual who can be described as the one who knows Your precepts. Ira the Ya’irite was his teacher and brought him near.
Rabbi Yehoshua of Sikhnin in the name of Rabbi Levi: They are six who were chosen: Priesthood, Levites, Israel, the royal house of David, Jerusalem, the Temple. Priesthood, from where is it derived? It is as it is written: “And chose it from all the tribes of Israel to be priests for Me” (I Samuel 2:28). Levites, from where is it derived? It is as it is stated: “For the Lord your God has chosen him from all your tribes” (Deuteronomy 18:5). Israel, from where is it derived? It is as it is stated: “The Lord your God has chosen you” (Deuteronomy 7:6). The royal house of David, from where is it derived? It is as it is stated: “He chose David His servant.” (Psalms 78:70). Jerusalem, from where is it derived? It is as it is stated: “[Jerusalem,] the city that I have chosen” (I Kings 11:32). The Temple, from where is it derived? It is as it is written: “I have chosen and sanctified this House” (II Chronicles 7:16).
David said: Happy is one whom the Holy One blessed be He has chosen and happy is one whom He brought near. Who is doubly happy? It is one whom the Holy One blessed be He has chosen and brought near. Who is that? It is Aaron and Levi. Aaron, from where is it derived? It is as it is stated: “And chose it from all the tribes of Israel to be priests for Me” (I Samuel 2:28). From where is it derived that He brought him near? It is as it is stated: “And you, bring Aaron your brother near to you” (Exodus 28:1).
Levi, the Holy One blessed be He chose him, as it is stated: “For the Lord your God has chosen him” (Deuteronomy 18:5). From where is it derived that He brought him near? It is as it is stated: “Bring the tribe of Levi near, and stand it.” In their regard, the verse says: “Happy is the one You choose to bring near to You to dwell in Your courtyards” (Psalms 65:5), just as it says: “They shall keep his commission, and the commission of the entire congregation…[to perform the service of the Tabernacle]” (Numbers 3:7). “May we be sated by the bounty of Your House, [the holiness of Your Temple]” (Psalms 65:5) – as they would eat all the tithes that were brought to the House, just as it says: “To the children of Levi, I have hereby given all tithe in Israel as an inheritance…” (Numbers 18:21).

R. Dusthai, of the city of Biri, lectured: "Unto what may be likened the system of David's praver? "Unto a peddler who wanted to sell out his stock little by little. He said before the Holy One, praised be He! (Ps. 19,13-15) 'Sovereign of the Universe, who can guard against errors?' And he was answered, 'They will be forgiven.' (Ib.) 'From secrets (faults) do Thou cleanse me.' 'They will be forgiven.' (Ib.) 'Also from presumptuous sins withhold Thy servants.' 'This will [also] be forgiven.' (Ib.) 'Let them not have dominion over me,' i.e., the Rabbis shall not talk about me. 'This will [also] be allowed to you.' (Ib.) 'Then shall I be blameless,' i.e., my sins shall not be written. And he was answered, 'This is impossible, for, if the Yud which I took away from the name of Sarai complained before me several years, until Joshua came and I added it to his name, as it is said (Num. 13, 16) And Moses called Hoshea; the son of Nun, Joshua, how much more [will there be complaints] if I omit a whole portion of the Torah?' (Ps. 19) Clear from any great transgression, i.e., He said before him: 'Sovereign of the Universe, forgive me the whole sin.' And he was answered, 'It is revealed before Me what Solomon, thy son, will say in his wisdom in the future (Pr. 6, 27-30) Can a man take fire in his bosom, and his clothes not be burnt? Or can one walk upon hot coals, and shall his feet not be scorched? So he that goeth in to his neighbor's wife; whosoever touches her shall not go unpunished.' He then exclaimed, 'If so, then I am lost.' And he was answered: 'Accept affliction upon thyself.' Immediately David accepted affliction upon himself." R. Juda said in the name of Rab: "Six months was David afflicted with leprosy; the Shechina left him, and the Sanhedrin separated themselves from him. He was inflicted with leprosy, as it is written (Ps. 51, 9) Purge me [from sin] with hyssop, etc. The Shechina left him, as it is written (Ib., ib., 14) Restore unto me the gladness of Thy salvation. The Sanhedrin separated themselves from him, as it is written (Ib. 119, 79) Let those that fear Thee return unto me and they that know Thy testimonies. That all this lasted fully six months — when do we learn it? From the following passage (I Kings, 2, 11) And the days that David reigned over Israel were forty years; (Ib. b) In Hebron he reigned thirty-three years over all Israel and Judah. Hence we see that the six months more [which are counted in II Samuel] are not counted [in I Kings], and this was because the six months in which he was inflicted with leprosy were not counted." (Ps. 86, 17) Display on me a sign for good, etc. Thus said David before the Holy One, praised be He! "Sovereign of the universe, forgive me this sin [of Bath Sheba]." "Thou art forgiven," answered the Lord. David then said to the Lord: "Show me a sign while I live." Whereupon He answered, "During thy life I shall not make it known but during the life of Solomon, thy son, I shall make it known." When Solomon had built the Temple he desired to place the ark in the holy of holies, but the gates had become fastened to each other [and they could not be opened]. Solomon then offered twenty-four prayer-songs but was not answered. He then said the prayer (Ps. 24, 9) Raise your heads, O ye gates, and raise up, ye everlasting doors, and let the King of glory enter. Who is the King of glory, the Lord of Hosts, He is the King of glory, Selah (II Chr. 6, l2). Still he was not answered; but as soon as he said O Lord God, turn not away the face of Thy anointed, remember the pious deeds of David Thy servant, he was immediately answered. At that moment the faces of David's enemies turned black like the bottom of a pot and then it was known to all that the Holy One, praised be He! had forgiven David that sin.