How to grant model permission to role

FH-4576 40 Reputation points
2023-11-09T08:52:14.86+00:00

I use a tabular model.

I need to grant model permission to one role.

Can I use a TSQL statement to do it like Sql server Admin grants permissions?

Thank.

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,297 questions
0 comments No comments
{count} votes

Accepted answer
  1. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-11-09T08:59:45.8566667+00:00

    Hi @FH-4576

    Actually, you can use SQL Server Management Studio (SSMS) to manage roles and permissions for a tabular model.

    You can refer to this.

    https://learn.microsoft.com/en-us/analysis-services/multidimensional-models/grant-cube-or-model-permissions-analysis-services?view=asallproducts-allversions

    Best regards,

    Percy Tang

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 45,366 Reputation points
    2023-11-09T09:37:33.97+00:00

    T-SQL is for the relational database.

    For SSAS tabular you can use TMSL = Tabular Model Scripting Language

    For roles see https://learn.microsoft.com/en-us/analysis-services/tmsl/roles-object-tmsl?view=asallproducts-allversions

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.