Forum Discussion

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
9 months ago
Solved

One Lake Security implementation doubts

Hey,   So am trying to identify how to implement One Lake Security. The goal is to provided self-service for departments which will have each their own workspace, by allowing them access throught s...
governance
one lake
security
  • V-yubandi-msft's avatar
    V-yubandi-msft
    9 months ago

    Hi afbraga66 ,
    If you need RLS to function properly, ensure your queries are run through the SQL Endpoint.
    When using a notebook, use %sql for queries that require RLS, as standard Spark reads (spark.read) do not enforce it yet.

     

    Thanks for your time.

afbraga66's avatar
afbraga66
Icon for Helper III rankHelper III
9 months ago

Hey,

 

It is still not clear to me how is a user supposed to run spark notebooks and have the rls be applied, if a viewer user cannot run queries. Thank you.

 

Best regards,

Andre

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
9 months ago

Hi afbraga66 ,
If you need RLS to function properly, ensure your queries are run through the SQL Endpoint.
When using a notebook, use %sql for queries that require RLS, as standard Spark reads (spark.read) do not enforce it yet.

 

Thanks for your time.