Forum Discussion

nivasnalla's avatar
nivasnalla
Frequent Visitor
7 years ago
Solved

Direct query with dynamic row level security authentication

Hello,    I am trying to figure out how the authentication mechanism work with direct query from the service to data gateway and to the  SQL Server. I know how the AS Live connection authentication...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi nivasnalla,

     

    You can try a software like SQL Server Profiler then you will see it clearly what happens in the Server side. Please refer to the snapshot below. I defined a role [Color] = "Blue". 

    Direct_query_with_dynamic_row_level_security_authentication

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi nivasnalla,

 

You can try a software like SQL Server Profiler then you will see it clearly what happens in the Server side. Please refer to the snapshot below. I defined a role [Color] = "Blue". 

Direct_query_with_dynamic_row_level_security_authentication

 

Best Regards,

Dale