<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div>Hi there,</div>
<div>it looks like it is feasible:</div>
<div>
<ol>
<li><a
href="https://stackoverflow.com/questions/31925882/mysql-can-i-implement-row-level-and-column-level-security"
class="question-hyperlink">MySQL: can I implement row-level
AND column level security?</a></li>
<li><a moz-do-not-send="true"
href="https://mariadb.com/resources/blog/protect-your-data-row-level-security-in-mariadb-10-0/">Protect
Your Data: Row-level Security in MariaDB 10.0</a></li>
</ol>
<p>and some supporting documentation: <br>
</p>
<ol>
<li><a moz-do-not-send="true"
href="https://severalnines.com/blog/ten-tips-how-achieve-mysql-and-mariadb-security">Ten
Tips on How to Achieve MySQL and MariaDB Security</a></li>
<li><a
href="https://support.chartio.com/knowledgebase/mysql-table-level-permissions">MySQL
Table and Column Level Permissions.</a></li>
<li><a moz-do-not-send="true"
href="https://mariadb.com/resources/blog/dynamic-columns-tutorial-part-1-introduction/">Dynamic
Columns Tutorial – Part 1: Introduction</a></li>
</ol>
<p>I'll keep on searching. Anyone else interested? <br>
</p>
<p>Stefan<br>
</p>
</div>
<div><br>
</div>
<div class="moz-cite-prefix">Am 25.10.2018 um 17:37 schrieb
<a class="moz-txt-link-abbreviated" href="mailto:digikam@911networks.com">digikam@911networks.com</a>:<br>
</div>
<blockquote type="cite"
cite="mid:20181025083750.221626e6@frogguski.911networks.com">
<pre class="moz-quote-pre" wrap="">On Thu, 25 Oct 2018 12:50:15 +0200
Stefan Mueller <a class="moz-txt-link-rfc2396E" href="mailto:stefan.mueller.83@gmail.com"><stefan.mueller.83@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre class="moz-quote-pre" wrap="">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
<a class="moz-txt-link-rfc2396E" href="https://stackoverflow.com/questions/8369253/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></a>
would be nice to get a central authentication service, such as an
LDAP server involved, what runs anyway for the cloud etc.
</pre>
</blockquote>
<pre class="moz-quote-pre" wrap="">
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.
</pre>
</blockquote>
</body>
</html>