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.

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

Hi afbraga66 ,
May I know if your issue is resolved? If you need any further help, please let us know.

  • 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.