- 12491 Views
- 8 replies
- 11 kudos
Resolved! Databricks SQL View with table access control
Hello,I want to grant 'select' option on some columns in my table.So i created view, and now people can access my view but cannot access the table.However, they cannot do 'select' on the view, because they do not have privileges to the table.What can...
- 12491 Views
- 8 replies
- 11 kudos
- 11 kudos
To sum up,It is not possible to create a view based on a table that someone does not have permission to.It's a pity, because this option would be very useful to limit access to batch-fed tables.Thanks all for the help and your time!Regards,Łukasz
- 11 kudos
- 1609 Views
- 0 replies
- 4 kudos
Table Access Control without High-Concurrency and with R
As we are starting to build our Lakehouse solution on Databricks, we need ACLs to be active. So far I have found two options:via UI or terraform: create a high-concurrency cluster and enable table access control for python and SQL. In terraform this ...
- 1609 Views
- 0 replies
- 4 kudos