Forum Discussion

Ahlisman's avatar
Ahlisman
Regular Visitor
6 years ago

RLS in SSDT

Hi im developing my first Star schema in Visual Studio. We are deplying it in Azure analysis. 

 

I have 10 Dim_tables and 5 Fact_tables. As we have a multi tennat db have we clientID for every client to seperate them. I have been able to active the RLS on some relationsships but I have two fact tables that I cant activate it on. I have added the ClientId in the Dim table and want to active the RLS on the relationship between the Dim and Fact table.


I cant see any differeces between this two fact tables comparing the 3 others that I was able to active.

Is there any special to think about, what can I have missed?

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    6 years ago

    Ahlisman ,

     

    Not very clear about your issue, generally, check if the relationship and direction have been set correctly. If you still can't solve this issue, please show the table structure/relationship and clarify more details about the issue.

     

    Regards,

    Jimmy Tao

    • Ahlisman's avatar
      Ahlisman
      Regular Visitor
      6 years ago

      Hi I can activate the row level security to all fact except Fact_Invoice and Fact_SupplierInvoice. Do I need to active the row level security? Right now have I only set one ClientId in the role settings, but I will add it dynamic later when i get this working.
      And should I have the clientId in both fact and dim tables? If I only set it in the fact tables can I see all clients employees and not just this specific client i have in the role.

      Here is a picture of some part of the schema. I have inactived the relationships that are not working to set the row level security on so it will be easier to see.