system schemas permission

seckinaktas
New Contributor II

‎11-21-2024 04:40 AM

Hi,
I'm an account admin on Databricks and  when I try to set select permission for system schemas

I take "PERMISSION_DENIED: User is not an owner of Schema 'system.compute'." 

When I try to set permission for system catalog,

I take "Requires ownership of catalog ‘system’".

I tried to run the following query but I'm stuck here

GRANT USE SCHEMA ON SCHEMA system.compute TO `client_id`;
GRANT SELECT ON TABLE system.compute.clusters TO `client_id`;
GRANT USE SCHEMA ON SCHEMA system.billing TO `client_id`;
GRANT SELECT ON TABLE system.billing.list_prices TO `client_id`;
GRANT SELECT ON TABLE system.billing.usage TO `client_id`;



Thank you

0 Kudos

Walter_C
Databricks Employee
Databricks Employee

‎11-21-2024 05:23 AM

As per documentation you need to be both Account Admin and Metastore Admin to be able to grant access to system tables:

Access to system tables is governed by Unity Catalog. No user has access to these system schemas by default. To grant access, a user that is both a metastore admin and an account admin must grant USE and SELECT permissions on the system schemas.

View solution in original post

seckinaktas
New Contributor II

‎11-21-2024 05:50 AM - edited ‎11-21-2024 05:51 AM

Thank you so much

0 Kudos