We have been using Hive Metastore in Databricks workspaces and recently enabled Unity Catalog for one of the workspace. However, we are encountering issues while applying grants on databases. The system is complaining, stating that table access control is not enabled on the cluster, despite us enabling ACL on the cluster.
actual error is : Query GRANT SELECT ON DATABASE database_name TO 'user_id': nested exception java.sql.SQLEXCEPTION : [Databricks][DaatbricksJDBCDriver][500051] Error Processing query/statement.
Error Code: 0, SQL state: org.apache.hive.service.HiveSQL Exception: Erorr running query: [_LEGACY_ERROR_TEMP_DBR_0127]
org.apache.spark.SparkException: Trying yo perform permission action on hive metastore '/CATLOG/hive_metastore/database_name' but the Table access control is not enabled on the cluster.
And we are using cluster on DBR 7.3 LTS and using Databricks 2.6.29 JDBC driver.
