MySQL Permission 'Select Only'
Posted on 2012-09-17
I have a situation where I would like for someone to be able to connect to a database and issue a query to select data only. Nothing else.
I'm assuming, for example when using c-Panel, that this is accomplished by simply choosing 'select' under user permissions for the db.
But would I need to provide any other permission other than 'select'?
Here are the choices available in the c-Panel MySQL user permissions:
CREATE TEMPORARY TABLES
Obviously I don't want to permit any 'create', 'drop', 'delete', 'insert' or 'update', but what about Index, Lock Tables, Execute and References.
Would it be necessary to grant any of these to perform a simple select query against the db?