How to grant model permission to role

Question

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.

Answer 1

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

Answer 2

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