We have a problem with users having permissions to create tables inn the legacy hive_metastore.
This only happens when using a personal cluster and when table location is not set. The default catalog has been set to main in the workspace, and users are not permitted to create tables there.
We have tried to only give users use_schema permissions in hive_metastore.default, deny access on the same schema, but Databricks seems to overwrite this.
How can we manage this? We dont want users to be able to create tables there.