[Digikam-devel] [digikam] [Bug 330168] New: allow read only mysql database

[Kusi]

https://bugs.kde.org/show_bug.cgi?id=330168

            Bug ID: 330168
           Summary: allow read only mysql database
    Classification: Unclassified
           Product: digikam
           Version: 3.5.0
          Platform: unspecified
                OS: Linux
            Status: UNCONFIRMED
          Severity: wishlist
          Priority: NOR
         Component: Database
          Assignee: digikam-devel at kde.org
          Reporter: kusi at forum.titlis.org

Please allow accessing the digikam schema (mysql) with a user who only has
"select" privileges.

Whenever you start digikam, it errors with the following message: 

"You have insufficient privileges on the database. Following privileges are not
assigned to you: ALTER TABLE Check your privileges on the database and restart
digiKam."

The same error message appears with "CREATE TABLE"

The previously entered collection is gone. Once re-entered in the settings,
everything works fine. You see all the tags, but cannot modify the tags. You
restart digikam and the error message pops up and the collection is gone, again





Reproducible: Always

Steps to Reproduce:
1. create a mysql user with SELECT privileges only
2. use digikam in mysql-mode with previously generated read only user
3. 
Actual Results:  
collection in settings disappeared

Expected Results:  
1) When starting with a read-only mysql-user, maybe a warning or indication
that digikam db is in read only mode.
2) don't kill my collection from settings every time I launch digikam

-- 
You are receiving this mail because:
You are the assignee for the bug.