https://community.databricks.com/t5/warehousing-analytics/error-with-grant-in-databricks-sql/m-p/33838#M755 <P>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.</P><P></P><P>Default:</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/2254iC3BFB74BB86E3DF1/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>Uncheck Limit to fix this.</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/2258i44FF8C7B281191C0/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>&nbsp;</P><P></P> Fri, 03 Dec 2021 14:31:21 GMT Prabakar 2021-12-03T14:31:21Z https://community.databricks.com/t5/warehousing-analytics/error-with-grant-in-databricks-sql/m-p/33837#M754 <P>While trying to GRANT SELECT permissions for a Database or Table it reports the below error.</P><PRE><CODE>Error running query Operation not allowed: GRANT(line 1, pos 0) == SQL == GRANT SELECT ON DATABASE my_database TO `my_table` LIMIT 1000 ^^^</CODE></PRE><P></P> Fri, 03 Dec 2021 14:15:44 GMT https://community.databricks.com/t5/warehousing-analytics/error-with-grant-in-databricks-sql/m-p/33837#M754 Prabakar 2021-12-03T14:15:44Z https://community.databricks.com/t5/warehousing-analytics/error-with-grant-in-databricks-sql/m-p/33838#M755 <P>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.</P><P></P><P>Default:</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/2254iC3BFB74BB86E3DF1/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>Uncheck Limit to fix this.</P><P><span class="lia-inline-image-display-wrapper" image-alt="image"><img src="https://community.databricks.com/t5/image/serverpage/image-id/2258i44FF8C7B281191C0/image-size/large?v=v2&amp;px=999" role="button" title="image" alt="image" /></span>&nbsp;</P><P></P> Fri, 03 Dec 2021 14:31:21 GMT https://community.databricks.com/t5/warehousing-analytics/error-with-grant-in-databricks-sql/m-p/33838#M755 Prabakar 2021-12-03T14:31:21Z