Have an issue with MYSQL and permissions.
I have a datacenter that uses mysql and have given me a read only user account.
Since I cannot modify his tables, what I have been doing is creating views and making datasets to report on from within my dev enviroment.
I then send the views to the datacenter admin and he creates them for me.
The issue is timing…
Does anyone know if there is a way to give permissions to a user to just create and drop views only without giving permissions to create / drop the tables too?
Kev