Best Practices for Role-Based Privilege Management in Databases

Research the best practices for managing and securing role-based privileges in databases and address the following questions in your discussion post:

What are the key challenges in managing role-based privileges, and how do they impact database security?
Can you provide a real-world scenario where poor role-based privilege management led to a security breach?
What specific best practices can be implemented to improve the management of role-based privileges, including the principle of least privilege