Azure SQL Analytics permissions

%3CLINGO-SUB%20id%3D%22lingo-sub-820276%22%20slang%3D%22en-US%22%3EAzure%20SQL%20Analytics%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820276%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Guys%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20figure%20out%20the%20way%20of%20giving%20people%20access%20Azure%20SQL%20Analytics.%20Do%20I%20have%20to%20create%20a%20custom%20role%20for%20it%20or%20just%20assign%20some%20special%20role%20assignment%20on%20a%20solutions%20itself%20or%20DB%3F%20Documentation%20is%20not%20specifying%20this%20correctly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fazure-sql%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fazure-monitor%2Finsights%2Fazure-sql%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-820276%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-995955%22%20slang%3D%22en-US%22%3ERe%3A%20Azure%20SQL%20Analytics%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-995955%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391409%22%20target%3D%22_blank%22%3E%40mrktos%3C%2FA%3E%26nbsp%3BI%20would%20create%20the%20custom%20role%20as%20outlined%20in%20the%20article%20you%20referenced.%20Then%20navigate%20to%20the%20Log%20Analytics%20Workspace%20you're%20using%20with%20SQL%20Analytics%20and%20assign%20the%20custom%20role%20to%20your%20users%20there.%20Should%20work%20then.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hey Guys,

 

I am trying to figure out the way of giving people access Azure SQL Analytics. Do I have to create a custom role for it or just assign some special role assignment on a solutions itself or DB? Documentation is not specifying this correctly.

 

https://docs.microsoft.com/en-us/azure/azure-monitor/insights/azure-sql

1 Reply

@mrktos I would create the custom role as outlined in the article you referenced. Then navigate to the Log Analytics Workspace you're using with SQL Analytics and assign the custom role to your users there. Should work then.