can not set permission in table

[arkiboys]

In databricks database table I was able to set permissions to groups but Now I get this error when using a cluster:

Error getting permissions

summary: SparkException: Trying to perform permission action on Hive Metastore /CATALOG/`hive_metastore`/DATABASE/`db_name`/TABLE/`tbl_name` but Table Access Control is not enabled on this cluster., data: com.databricks.backend.common.rpc.SparkDriverExceptions$SQLExecutionException: org.apache.spark.SparkException:

Table access control is indeed enabled in the security tab when I am inside the Admin settings.

The cluster version I am using is:

policy --> unrestricted
Access mode --> No Isolation shared
worker type --> standard_D8_v3
driver type --> standard_D8_v3

[Kaniz_Fatma · Accepted solution]

Hi @arkiboys, It seems you’re encountering an issue related to permissions and table access control in Databricks. Let’s troubleshoot this together.

1. Table Access Control Not Enabled: The error message indicates that Table Access Control is not enabled on your cluster. This feature allows you to manage permissions for tables and databases within Databricks. To resolve this, follow these steps:

   • Check Cluster Configuration:

     • Confirm that the cluster you’re using has the correct configuration. You mentioned the following settings:
       • Policy: Unrestricted
       • Access Mode: No Isolation Shared
       • Worker Type: standard_D8_v3
       • Driver Type: standard_D8_v3
     • Ensure that these settings align with your requirements.

   • Verify Table Access Control:

     • Go to your Databricks workspace.
     • Navigate to the Admin Console.
     • Under Security, check if Table Access Control is indeed enabled. If not, enable it.

2. Permissions API:

   • You can manage cluster permissions programmatically using the Permissions API. This allows you to set permissions for different workspaces, clusters, and other resources. Refer to the Databricks documentation for detailed information on how to use the API.

3. Granting USAGE Privilege:

   • If you’re dealing with database access, consider granting the USAGE privilege to the user group. This privilege was introduced in Databricks Runtime 7.3 LTS and above.
   • As an admin user, open a notebook and run the following command:

     GRANT USAGE ON DATABASE db_name TO user_group;
     

     Replace db_name with your database name and user_group with the appropriate group.

4. Cluster Creation Permissions:

   • Sometimes, the error may be related to cluster creation permissions. Ensure that the Allow unrestricted cluster creation permission is correctly configured for the relevant user or group.
   • Additionally, check if any Cluster Policies (defined on the Compute tab) are affecting cluster creation permissions.

Remember to verify each step carefully, and feel free to ask for further assistance if needed! 🚀