topic on Databricks how to set RLS(role level security) in Data Governance

on Databricks how to set RLS(role level security)

FanMichelleTW — Tue, 12 Aug 2025 09:04:30 GMT

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 ?

Re: on Databricks how to set RLS(role level security)

BS_THE_ANALYST — Tue, 12 Aug 2025 09:20:07 GMT

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

Re: on Databricks how to set RLS(role level security)

BS_THE_ANALYST — Tue, 12 Aug 2025 09:26:46 GMT

@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

Re: on Databricks how to set RLS(role level security)

BS_THE_ANALYST — Sat, 16 Aug 2025 13:34:50 GMT

@FanMichelleTW any further forward with this?

All the best,
BS