How to provide table level access to users in ADX

%3CLINGO-SUB%20id%3D%22lingo-sub-2767147%22%20slang%3D%22en-US%22%3EHow%20to%20provide%20table%20level%20access%20to%20users%20in%20ADX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2767147%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20in%20the%20azure%20portal%2C%20where%20I%20can%20provide%20database%20level%20access.%20However%20I%20could%20see%20Table%20Admin%20and%20Table%20Ingestor%20roles%20are%20available%20per%20the%20documentation.%3C%2FP%3E%3CP%3EMy%20requirement%20is%2C%20I%20should%20be%20able%20to%20provided%20access%20to%20users%20to%20only%20specific%20table%20in%20a%20database.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2767147%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20Data%20Explorer%20(Kusto)%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EKusto%20language%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2807268%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20provide%20table%20level%20access%20to%20users%20in%20ADX%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2807268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1161096%22%20target%3D%22_blank%22%3E%40bharathbathina%3C%2FA%3E%2C%20You%20can%20provide%20access%20to%20users%20at%20database%20level-%3C%2FP%3E%3CP%3E1.%20Go%20to%20ADX%20Cluster%3C%2FP%3E%3CP%3E2.%20Select%20your%20ADX%20Database%3C%2FP%3E%3CP%3E3.%20A%20new%20window%20will%20open%3C%2FP%3E%3CP%3E4.%20Go%20to%20permission%20section%20in%20left%20pane%3C%2FP%3E%3CP%3E5.%20Click%20on%20Add%20and%20choose%20either%20of%20the%20options%20available%20as%20per%20your%20choice%26nbsp%3B%3C%2FP%3E%3CP%3E6.%20Now%20search%20for%20the%20user%20and%20select%20the%20user%20to%20provide%20the%20access%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have tried in the azure portal, where I can provide database level access. However I could see Table Admin and Table Ingestor roles are available per the documentation.

My requirement is, I should be able to provided access to users to only specific table in a database.

2 Replies

@bharathbathina, You can provide access to users at database level-

1. Go to ADX Cluster

2. Select your ADX Database

3. A new window will open

4. Go to permission section in left pane

5. Click on Add and choose either of the options available as per your choice 

6. Now search for the user and select the user to provide the access

 

@yaswantsinghi Thanks for sharing your response.

 

I am looking at table level, so trying to utilize Row Level Security and Unrestricted viewer access policies to achieve. But would like to know if we have any other direct options to provide access on table level.

 

Thank you