We have several core db tables on our system and allow our employees access to these tables via views that just show them the data they need to see.
We created these views in a new db specific to the new user. Creating all of these views requires running several mysql queries.
I would like to automate this process into a script, but feel there must be tools already out there that take a list of queries and run them.
Can anyone recommend any such tools or even any built-in features in mysql that could assist me here ?