Skip to content

I suggest you ...

← Feature Request

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.

3 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Report

    To whom may read this:
    grant select, update,insert,delete on database.gnclock to 'whoever'@'%'
    with
    grant select on database.* to 'whoever'@'%'

    works wonders.
    however you will need to use "open" with the read-only tick-mark everytime... the "recently opened dosent save read-only or not.

Feature Request

Categories

Feedback and Knowledge Base

(thinking…)