GRANT PRIVILEGES or REVOKE not working in databricks: Operation not allowed
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 07:18 AM
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!
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-27-2023 08:11 AM
Hi @João Peixoto In my case, it's working fine, I am able to grant and revoke the access by using spark SQL.
Ajay Kumar Pandey
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2023 06:56 AM
Its solved, the problem was I was using '' insted of ``
