This is what im trying to do, to save a TON of time managing user permissions with our countless tables.
Is there a way to give a user access to every table, save one or two tables? Without having to do each table individually? Basically give someone root access to the whole DB except one or two DBs that we dont want them touching. It was suggested that a script could be written to loop through all the tables i wanted and insert the table names into mysql.tables_priv. Thanks for any suggestions or resolutions to this.
Is there a way to give a user access to every table, save one or two tables? Without having to do each table individually? Basically give someone root access to the whole DB except one or two DBs that we dont want them touching. It was suggested that a script could be written to loop through all the tables i wanted and insert the table names into mysql.tables_priv. Thanks for any suggestions or resolutions to this.