Psalm 51 records the confession of David after he is confronted about his adulterous relationship with Bathsheba by the prophet Nathan.  This honest prayer is one of the reasons David is considered a man after God's own heart.