Can I implement Row Level Security for users when using SQL Endpoints?

User16826992666 — Fri, 21 Mar 2025 12:50:35 GMT

I'd like to be able to limit the rows users see when querying tables in Databricks SQL based on what access level each user is supposed to be granted. Is this possible in the SQL environment?

Re: Can I implement Row Level Security for users when using SQL Endpoints?

sajith_appukutt — Fri, 18 Jun 2021 22:20:13 GMT

Using dynamic views you can specify permissions down to the row or field level

e.g.

CREATE VIEW sales_redacted AS
SELECT
  user_id,
  country,
  product,
  total
FROM sales_raw
WHERE
  CASE
    WHEN is_member('managers') THEN TRUE
    ELSE total <= 1000000
  END;

More details at https://docs.databricks.com/security/access-control/table-acls/object-privileges.html#row-level-permissions

topic Can I implement Row Level Security for users when using SQL Endpoints? in Warehousing & Analytics

Can I implement Row Level Security for users when using SQL Endpoints?

Re: Can I implement Row Level Security for users when using SQL Endpoints?