Table Level Security

Question

Table Level Security

Nathan Sommer 40

I'm trying to grant access for certian groups based on tables. Right now everyone can see everything, only specific people need to see certain tables. How do I fix this?

Thanks,

Nathan

Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator

2025-11-07T13:30:49.36+00:00

Hi Nathan Sommer,

Just checking to see if you have a chance to check my previous response and helped, do let me know if you have any further questions on this.

If the provided information answers your query, do click "Upvote" and "Accept Answer", it will help others who might be facing similar challenges.

Thanks

Kalyani
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator

2025-11-10T08:50:40.5933333+00:00

Hi Nathan Sommer,

we haven't received a response from you regarding the last response. If you've found a resolution, we’d greatly appreciate it if you could share it with the community, as it might benefit others. If not, please let us know, and we’ll provide further details and do our best to assist you.

1 answer

Your answer

Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator

2025-11-07T13:30:49.36+00:00

Hi Nathan Sommer,

Just checking to see if you have a chance to check my previous response and helped, do let me know if you have any further questions on this.

If the provided information answers your query, do click "Upvote" and "Accept Answer", it will help others who might be facing similar challenges.

Thanks

Kalyani
Kalyani Kondavaradala 4,595 Reputation points Microsoft External Staff Moderator

2025-11-10T08:50:40.5933333+00:00

Hi Nathan Sommer,

we haven't received a response from you regarding the last response. If you've found a resolution, we’d greatly appreciate it if you could share it with the community, as it might benefit others. If not, please let us know, and we’ll provide further details and do our best to assist you.

Answer 1

Hi Nathan Sommer,

Thanks for reaching on Microsoft Q&A!

Can you please check below things to fix the issue and let us know

Security Roles: Assign different security roles based on your access needs. Azure Data Explorer allows the assignment of roles at various levels, including at the table level. You can learn more about how to manage Security Roles here.
To restrict access to specific tables, you can turn on the Restricted View Access policy for those tables. This policy ensures that only principals with the unrestrictedViewer role can access the table. Meanwhile, principals with the regular viewer role can't view the table.
Restrict All: Apply the RestrictedViewAccess = true policy to all sensitive tables.
Allow Restricted: Grant the Database UnrestrictedViewer role to the specific group that should see the sensitive tables.
Allow General: Grant the basic Database Viewer role to everyone else who needs general read access to the non-sensitive data.

https://learn.microsoft.com/en-us/kusto/management/manage-table-view-access?view=azure-data-explorer

I hope this helps you, please let us know if you have further queries on this.

Kindly consider upvoting and accept the answer if the given information is useful, this will help other who are facing similar challenges like you.

Thanks!

Kalyani

Share via

Table Level Security

1 answer

Your answer