Error with GRANT in Databricks SQL

Prabakar · ‎12-03-2021

While trying to GRANT SELECT permissions for a Database or Table it reports the below error.

Error running query
Operation not allowed: GRANT(line 1, pos 0)
== SQL ==
GRANT SELECT ON DATABASE my_database TO `my_table` LIMIT 1000
^^^

Prabakar · ‎12-03-2021

In Databricks SQL, by default, the Limit clause is enabled. So trying GRANT with limit will throw the error. Uncheck the Limit to execute the GRANT successfully.

Default:

Uncheck Limit to fix this.

View solution in original post