Re: Restricting data access at column and/or row level

[Nitan Kainth]

Thanks Stefan. What is tentative release time? Regards, Nitan Cell: 510 449 9629 On Oct 3, 2023, at 7:26 PM, Miklosovic, Stefan <stefan.mikloso...@netapp.com> wrote: Hi, columns can be restricted per user by Dynamic Data Masking (will be in 5.0). https://cassandra.apache.org/doc/trunk/cassandra/developing/cql/dynamic_data_masking.html I am not sure about specific rows. To my knowledge I do not think that is possible. ________________________________________ From: Nitan Kainth <nitankai...@gmail.com> Sent: Tuesday, October 3, 2023 23:31 To: cassandra Subject: Restricting data access  at column and/or row level You don't often get email from nitankai...@gmail.com. Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> 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. Hi Team, I have a requirement to grant select privileges on a table to some user restricting few columns and few rows. Something like this: c1 | c2 | c3 | c4 ----+----+----+----  5 |  1 |  5 |  1 10 |  1 |  1 |  1  1 |  1 |  1 |  1  8 |  1 |  1 |  1  2 |  1 |  1 |  1  4 |  1 |  1 |  1  7 |  5 |  1 |  1  6 |  1 |  1 |  1  9 |  1 |  1 |  1  3 |  4 |  1 |  1 User1 should be able to see only c1 and c2: c1 | c2 ----+----  5 |  1 10 |  1  1 |  1  8 |  1  2 |  1  4 |  1  7 |  5  6 |  1  9 |  1  3 |  4 User2 should be able to see only c1=5: c1 | c2 ----+----  5 |  1 I created Materialized view but unfortunately, it can’t work without granting permission on base table. Regards, Nitan Cell: 510 449 9629<tel:510%20449%209629>