Define a set of standards and policies for adding, modifying, and removing users from a database. Then, identify how to create a user in MySQL. Write the steps for creating a user in MySQL with a detailed flowchart. Finally, provide a scenario in which a role is assigned to another role to fulfill a specific need.