Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How to filter sales data by access rights defined in Azure SQL?

I have "ProjectAccess" table in Azure Server. It has columns "ProjectId", "AzureADEmailAddress".

I have "SalesFact" table with columns "SalesId", "ProjectId", "SalesTime","SalesAmount".

 

How do limit access for logined user so that he sees only Sales data where he have access rights based on ProjectAccess?

 

I know how role based security works, but this time access rights are defined in Azure SQL.

We can use Analysies Services Tabular model if needed to meet this requirement?

 

 

 

Need Help

2 Replies

  • quentin_vigne's avatar
    quentin_vigne
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi Anonymous

     

    If you have a table with email adress and right given, you can easily add Row Level Security to your report by using YourTable[YourColumn]=USERNAME() and putting it on your access table

     

    Quentin

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      1) I have Azure SQL column = "[email protected]"

      2) I create "ProjectManager" role.

      3) YourTable[YourColumn]= "[email protected]"  WORKED FINE

       

      4) YourTable[YourColumn]=USERNAME()                   RETURN NOTHING

       

      What could be wrong? Only UPN is supported?