kqlazure-data-explorerkusto-explorer

Need suggestion to implement restrictive permissions to Kusto Tables and Functions


I would like to restrict viewer permissions of a specific Security Group to all database objects except few functions. In other words, the members of that one security Group should be only able to see\execute 10 functions. Should not be able to directly query the table(s) schema.

Scenario Prototype Steps: I tried Restricted view access policy option.

My ask is, my Corp account should be able to execute the function fnGetTable1 but not directly query the table Table1. Is this possible?


Solution

  • Not a perfect solution, but possibly a workaround ? you might set up row level security on the table to limit the table output for certain users. As a result, restricted users would see table, but they would not see any data inside.