I have a shared cluster that is unity catalog enabled. I am able to do a:

select * from hive_metastore.clean.table_name

but when i try to create a table

%sql
CREATE TABLE hive_metastore.clean.dummy_new (
Name STRING,
Age LONG
)
USING DELTA
LOCATION 'abfss://[email protected]/path'

I get a SparkSecurityException: [INSUFFICIENT_PERMISSIONS] Insufficient privileges:
User does not have permission SELECT on any file. error.

With a sinlge user cluster i am able to create a table inside a hive metastore, same command no errors.

Upon reading documentation mentioned here
it says
Because compute resources that use shared access mode are enabled for legacy table access control by default, that means that if you use that access mode, you must have table access control privileges on the Hive metastore that you are migrating from. You can grant yourself access using the following SQL command:

GRANT all_privileges ON catalog hive_metastore TO `<user>`

Following this gives this error: AnalysisException: Action Unknown ActionType ALL_PRIVILEGES cannot be granted on CATALOG

Is the documentation wrong? Upon cross checking with my admin my user does have all the rights as shown below:

Will appreciate any help: the main goal is to be able to Use Hive Metastore without any problems while enabling Unity Catalog.