- 4286 Views
- 1 replies
- 0 kudos
Resolved! Can I implement Row Level Security for users when using SQL Endpoints?
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?
- 4286 Views
- 1 replies
- 0 kudos
Latest Reply
- 0 kudos
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 <= 1...
- 0 kudos