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