delta table access

Question

hello,

How is it possible to give to group1 access to table1, table2 and give group 2 access to table3 and table4?
Thank you

Answer 1

Hello arkiboys,

Please follow the below steps to give access to groups on the delta tables.

• Create Databricks groups that you want to give access. You can create groups from the admin settings
• Assign the users to each group. Edit the group and add members.
• Create delta tables
• Grant appropriate group access using the below syntax:

GRANT SELECT ON table1 TO group1;
GRANT SELECT ON table2 TO group1;

GRANT SELECT ON table3 TO group2;
GRANT SELECT ON table4 TO group2;

Please note:
As a pre-requisite, you need to enable table access control on the cluster.

SQL only table access control:
To enable SQL-only table access control on a cluster and restrict that cluster to use only SQL commands, set the following flag in the cluster’s Spark conf:

spark.databricks.acl.sqlOnly true

Reference documents:

How to enable table access control for your workspace:
https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/table-acl#--enable-table-access-control-for-your-workspace

https://learn.microsoft.com/en-us/azure/databricks/data-governance/table-acls/table-acl#--sql-only-table-access-control
https://learn.microsoft.com/en-us/azure/databricks/administration-guide/users-groups/users

I hope this helps.

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.