on Databricks how to set RLS(role level security)

FanMichelleTW
Databricks Partner

i try to find out SQL for RLS , the databricks geni give this feedback "In Databricks SQL, the CREATE ROW ACCESS POLICY statement is not supported" . it means we can set RLS (role level security) for managed table or external table ?

BS_THE_ANALYST
Databricks Partner

Hi @FanMichelleTW 

I think the documentation could be your friend here:
https://docs.databricks.com/aws/en/data-governance/unity-catalog/filters-and-masks 

some useful links from that page (found in the "how to apply filters and masks" section): https://docs.databricks.com/aws/en/data-governance/unity-catalog/filters-and-masks/manually-apply
https://docs.databricks.com/aws/en/data-governance/unity-catalog/abac/ (I think this attribute based access control is in beta). I heard about this on a databricks podcast on youtube. Sounded pretty cool! The link were they discussed ABAC is here, should you be interested: https://www.youtube.com/watch?v=7Juvwql3mF0 

All the best,
BS

View solution in original post

BS_THE_ANALYST
Databricks Partner

@FanMichelleTW if you're a fan of a video tutorial style, could you check this one out:
https://www.youtube.com/watch?v=VQc2J2Hdv_c 

It seems promising. I skimmed through the content. 

Let me know how you get on, @FanMichelleTW .

All the best,
BS

BS_THE_ANALYST
Databricks Partner

@FanMichelleTW any further forward with this?

All the best,
BS