[digiKam-users] Use digiKam with a NAS and MariaDB

[digikam at 911networks.com]

On Sun, 18 Nov 2018 21:12:31 +0100
"Stefan Müller" <stefan.mueller.83 at gmail.com> wrote:

> Hi there,
> it looks like it is feasible:
> • MySQL: can I implement row-level AND column level security?
> • Protect Your Data: Row-level Security in MariaDB 10.0

Sorry (I'm Canadian and we try to be polite), but I still don't think
that it's possible under the current conditions. 

DK doesn't track the users, therefore DK doesn't know which photo
belong to who.

If you can add the user information to the database then it might be
possible, with something like: userid-filename.extension, then create
views that are for each user, but in the end, you would still have to
modify the DK code to take count of that info.

Gilles is the "boss"...

> 
> and some supporting documentation:
> • Ten Tips on How to Achieve MySQL and MariaDB Security
> • MySQL Table and Column Level Permissions.
> • Dynamic Columns Tutorial – Part 1: Introduction
> 
> I'll keep on searching. Anyone else interested?
> 
> Stefan
> 
> Am 25.10.2018 um 17:37 schrieb digikam at 911networks.com:
> On Thu, 25 Oct 2018 12:50:15 +0200
> > Stefan Mueller <stefan.mueller.83 at gmail.com> wrote:
> > 
> > hey thx for the input.
> >> I will start a separate discussion to discuss details.
> >> I've jsut started collecting documentation about user accounts
> >> handling in mariadb.
> >> found only this so far:
> >> Grant user access to limited number of tables in MySQL
> >> <https://stackoverflow.com/questions/8369253/grant-user-access-to-limited-number-of-tables-in-mysql>
> >> would be nice to get a central authentication service, such as an
> >> LDAP server involved, what runs anyway for the cloud etc.
> >> 
> > This will not work because all the photos (and I imagine also the
> > videos) are in one table: "images" so all users need to have
> > access to that table if you want to share the database.
> > 
> > 


-- 
sknahT

vyS