topic Re: GRANT PRIVILEGES or REVOKE not working in databricks: Operation not allowed in Data Engineering

GRANT PRIVILEGES or REVOKE not working in databricks: Operation not allowed

Joao_DE — Fri, 27 Jan 2023 15:18:46 GMT

Hi everyone!

I am having a problem! I can Grant or Revoke privileges from users using the UI on databricks, but when I try to do that using SQL commands such as GRANT SELECT ON SCHEMA [... ] TO [USER]; I get an error stating Operation not allowed.

I am the owner of the schema and I am also an adm.

Thanks for your help in advance!

Re: GRANT PRIVILEGES or REVOKE not working in databricks: Operation not allowed

Ajay-Pandey — Fri, 27 Jan 2023 16:11:53 GMT

Hi @João Peixoto In my case, it's working fine, I am able to grant and revoke the access by using spark SQL.

Re: GRANT PRIVILEGES or REVOKE not working in databricks: Operation not allowed

Joao_DE — Thu, 02 Feb 2023 14:56:55 GMT

Its solved, the problem was I was using '' insted of ``