[prev in list] [next in list] [prev in thread] [next in thread]
List: cassandra-user
Subject: Re: Restricting data access at column and/or row level
From: Nitan Kainth <nitankainth () gmail ! com>
Date: 2023-10-04 11:17:10
Message-ID: D8E328F0-AB4C-4669-888E-F7BA03273BA7 () gmail ! com
[Download RAW message or body]
[Attachment #2 (text/html)]
<html><head><meta http-equiv="content-type" content="text/html; \
charset=utf-8"></head><body dir="auto">Thanks Stefan.<div><br></div><div>What is \
tentative release time?<br><br><div dir="ltr"><br><div>Regards,</div><div><p \
class="MsoNormal" style="margin: 0in 0in 0.0001pt;"><span style="background-color: \
rgba(255, 255, 255, 0);">Nitan<o:p></o:p></span></p><p class="MsoNormal" \
style="margin: 0in 0in 0.0001pt;"><span style="background-color: rgba(255, 255, 255, \
0);">Cell: <a href="tel:510%20449%209629" dir="ltr" \
x-apple-data-detectors="true" x-apple-data-detectors-type="telephone" \
x-apple-data-detectors-result="0">510 449 9629</a></span></p></div></div><div \
dir="ltr"><br><blockquote type="cite">On Oct 3, 2023, at 7:26 PM, Miklosovic, Stefan \
<Stefan.Miklosovic@netapp.com> wrote:<br><br></blockquote></div><blockquote \
type="cite"><div dir="ltr"><span>Hi,</span><br><span></span><br><span>columns can \
be restricted per user by Dynamic Data Masking (will be in \
5.0).</span><br><span></span><br><span>https://cassandra.apache.org/doc/trunk/cassandra/developing/cql/dynamic_data_masking.html</span><br><span></span><br><span>I \
am not sure about specific rows. To my knowledge I do not think that is \
possible.</span><br><span></span><br><span>________________________________________</span><br><span>From: \
Nitan Kainth <nitankainth@gmail.com></span><br><span>Sent: Tuesday, October 3, \
2023 23:31</span><br><span>To: cassandra</span><br><span>Subject: Restricting data \
access at column and/or row level</span><br><span></span><br><span>You don't \
often get email from nitankainth@gmail.com. Learn why this is \
important<https://aka.ms/LearnAboutSenderIdentification></span><br><span>NetApp \
Security WARNING: This is an external email. Do not click links or open attachments \
unless you recognize the sender and know the content is \
safe.</span><br><span></span><br><span></span><br><span></span><br><span>Hi \
Team,</span><br><span></span><br><span>I have a requirement to grant select \
privileges on a table to some user restricting few columns and few rows. Something \
like this:</span><br><span></span><br><span>c1 | c2 | c3 | \
c4</span><br><span>----+----+----+----</span><br><span> 5 | 1 | 5 | \
1</span><br><span>10 | 1 | 1 | 1</span><br><span> 1 | \
1 | 1 | 1</span><br><span> 8 | 1 | 1 | \
1</span><br><span> 2 | 1 | 1 | 1</span><br><span> \
4 | 1 | 1 | 1</span><br><span> 7 | 5 | 1 | \
1</span><br><span> 6 | 1 | 1 | 1</span><br><span> \
9 | 1 | 1 | 1</span><br><span> 3 | 4 | 1 | \
1</span><br><span></span><br><span>User1 should be able to see only c1 and \
c2:</span><br><span>c1 | c2</span><br><span>----+----</span><br><span> 5 | \
1</span><br><span>10 | 1</span><br><span> 1 | \
1</span><br><span> 8 | 1</span><br><span> 2 | \
1</span><br><span> 4 | 1</span><br><span> 7 | \
5</span><br><span> 6 | 1</span><br><span> 9 | \
1</span><br><span> 3 | 4</span><br><span></span><br><span>User2 \
should be able to see only c1=5:</span><br><span>c1 | \
c2</span><br><span>----+----</span><br><span> 5 | \
1</span><br><span></span><br><span>I created Materialized view but \
unfortunately, it can't work without granting permission on base \
table.</span><br><span></span><br><span></span><br><span>Regards,</span><br><span>Nitan</span><br><span>Cell: \
510 449 9629<tel:510%20449%209629></span><br><span></span><br></div></blockquote></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic