In azure analysis services, how to view permissions set on models using Java REST api? Any other alternative approaches/suggestions are welcome.

@Prashantha Hosapattana Which all permissions you are looking for ? It is possible through REST API though you can use a PowerShell script like below to get all roles and assigned members if you are looking for the same. [Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") $ServerName = "asazure://westus2.asazure.windows.net/<servername>" $DB = "adventureworks" $MyServer = New-Object Microsoft.AnalysisServices.Server $MyServer.Connect($ServerName) $myDatabase = $myServer.Databases.Item($DB) foreach ( $roles in $myDatabase.Model.Roles) { foreach ( $role in $roles) { Write-Output $role.Name Write-Output "----------------------" foreach ( $member in $roles.Members) { "Member Name: " + $member.Name Write-Output "`n" } Write-Output "`n" } }

azure analysis services - models

Accepted answer

Saurabh Sharma 23,806 Reputation points Microsoft Employee

2021-02-18T20:02:39.673+00:00
@Prashantha Hosapattana Which all permissions you are looking for ? It is possible through REST API though you can use a PowerShell script like below to get all roles and assigned members if you are looking for the same.

[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") $ServerName = "asazure://westus2.asazure.windows.net/<servername>" $DB = "adventureworks" $MyServer = New-Object Microsoft.AnalysisServices.Server $MyServer.Connect($ServerName) $myDatabase = $myServer.Databases.Item($DB) foreach ( $roles in $myDatabase.Model.Roles) { foreach ( $role in $roles) { Write-Output $role.Name Write-Output "----------------------" foreach ( $member in $roles.Members) { "Member Name: " + $member.Name Write-Output "`n" } Write-Output "`n" } }
Please sign in to rate this answer.

1 person found this answer helpful.
Prashantha Hosapattana 26 Reputation points

2021-02-19T04:20:42.657+00:00

Saurabh -Thank you very much for answering my post. It was very helpful. I have couple more questions

How can i get permission for all the models that exists in analysis service. Above example is good if we know the model name.

Can you guide me some REST API examples for the same, if you are aware of it.

Saurabh Sharma 23,806 Reputation points Microsoft Employee

2021-02-23T02:24:55.157+00:00

@Prashantha Hosapattana

In order to do that you need to traverse through all databases of $myserver and then iterate through model and roles. Something like below - foreach ( $databases in $myServer.Databases) {
$myDatabase = $myServer.Databases.Item($databases.Name) foreach ( $roles in $myDatabase.Model.Roles) {
foreach ( $role in $roles) {
Write-Output $role.Name
Write-Output "----------------------"
foreach ( $member in $roles.Members) {
"Member Name: " + $member.Name
Write-Output "n" } Write-Output "n"
}
}
}

I do not believe any REST API available for the same.

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.

Saurabh Sharma 23,806 Reputation points Microsoft Employee

2021-02-24T15:50:56.763+00:00

@Prashantha Hosapattana Please let me know if you find above reply useful. If yes, do click on 'Mark as answer' link in above reply. This will help other community members facing similar query to refer to this solution. Thanks.

Prashantha Hosapattana 26 Reputation points

2021-02-24T16:21:30.283+00:00

Saurabh- your reply was very useful. I accepted your answer so that it can be helpful to other community members.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

azure analysis services - models

0 additional answers

Your answer