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

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