Enable Table Access Control is not enabled on this cluster?

Question

Hello Team,

I am running this script:

GRANT USAGE, SELECT ON SCHEMA silver TO ******@xyz.com

And getting this error:

org.apache.spark.SparkException: Trying to perform permission action on Hive Metastore /CATALOG/hive_metastore/DATABASE/silver but Table Access Control is not enabled on this cluster.

Please advise me how it can be enabled.

Regards

Rohit

Answer 1

Hello @Rohit Kulkarni

Thanks for the question and using MS Q&A platform.

From the error message it looks like table access is not enabled on the cluster which you are using.

This article - Enable table access control for a cluster describes how to enable table access control for a cluster.

For information about how to set privileges on a data object once table access control has been enabled on a cluster, see Data object privileges.

Hope this helps. Do let us know if you any further queries.

---

Please don’t forget to Accept Answer wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hi @PRADEEPCHEEKATLA

Even I had the same issue,(Method public boolean org.apache.spark.sql.internal.CatalogImpl.databaseExists(java.lang.String) is not whitelisted on class class org.apache.spark.sql.internal.CatalogImpl)

Can you please suggest any solution on this.

but enabling the below controls, did not overcome the issue. User's image