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

[Joao_DE]

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!

[Ajay-Pandey]

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

[Joao_DE]

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