Change DBI test for mysql to allow proper read-only
Currently Mysql DBI back-end requires too permissive "grants" on database. There is a Read-only tick-box but it seems to require Update, insert and delete on database. also "locking" is achieved trough a table in said database where-as mysql already has "locking" facilities for its tables. i would like to be able to add a Select+execute only user so i can say give access to an accountant without giving write access...risking data corruption by 3rd party.
To whom may read this:
grant select, update,insert,delete on database.gnclock to 'whoever'@'%'
grant select on database.* to 'whoever'@'%'
however you will need to use "open" with the read-only tick-mark everytime... the "recently opened dosent save read-only or not.