Kodi Community Forum

I am trying to create a second user for my MySQL database that can view the library, but can only update watched and resume data. No edits to actual files (cant accidentally delete objects from library) for my android xbmc because I keep accidentally removing objects when I have missed a path sub, or one of the network drives is down.

I have tried creating a new user, giving select permissions on the entire db, and then adding all permissions to just files.playCount, files.lastPlayed, settings.resumeTime, and bookmark.*

But I cannot get resume points to transfer, or watched status to go unwatched.

Am I missing something?

The seris of commands I used for permissions is:

GRANT SELECT ON *.* TO 'xbmc_ro';
GRANT ALL ON files.playCount TO 'xbmc_ro';
GRANT ALL ON files.lastPlayed TO 'xbmc_ro';
GRANT ALL ON settings.resumeTime TO 'xbmc_ro';
GRANT ALL ON bookmark.* TO 'xbmc_ro';

Thanks in advance for any help