Technology advancement in the last few decades allows large penetration of renewable energy resources in the distribution network (DN). The integration of such resources has shown a substantial impact on DN through power loss reduction and improved network reliability. Besides this, the existing protection system has encountered coordination challenges due to the bidirectional power flow, different types and capacity of generation sources, and changes in fault levels due to network operating modes (grid-connected or islanded). Such conditions may cause the relays to malfunction and imperil the effectiveness of the existing protection scheme. Therefore, an efficient and robust protection coordination scheme is imperative to avoid network reliability and stability issues to the grid. This review paper presents a comparative analysis of various protection techniques implemented to alleviate the impact of integrated resources into DN. Moreover, a comparison of classical and modified protection approaches in terms of advantages, shortcomings, and implementation costs is presented. The prime objective of this study is to highlight the prominence of utilizing user-defined programmable relays for modern DNs. Moreover, recommendations are presented by considering the application of user-defined relay characteristics that can be proved as a robust protection scheme to cope with the protection challenges in existing and future power systems developments.