I'm working on creating a 'read-only' mysql database. I want the user to be able to see everything, but not be able to modify anything. My user currently has the following grants:
GRANT USAGE ON . TO 'sqlprostudio-ro'@'%' IDENTIFIED BY PASSWORD '*x' GRANT SELECT, EXECUTE, SHOW VIEW ON northwind.* TO 'sqlprostudio-ro'@'%'
I can see stored procedures, but if I run:
SHOW CREATE PROCEDURE x
The 'Create procedure' column returns null. Is there a way I can allow a read-only user to see the creation procedure without being able to modify it?