cancel
Showing results for 
Search instead for 
Did you mean: 
Administration & Architecture
Explore discussions on Databricks administration, deployment strategies, and architectural best practices. Connect with administrators and architects to optimize your Databricks environment for performance, scalability, and security.
cancel
Showing results for 
Search instead for 
Did you mean: 

system schemas permission

seckinaktas
New Contributor II

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

1 ACCEPTED SOLUTION

Accepted Solutions

Walter_C
Databricks Employee
Databricks Employee

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

2 REPLIES 2

Walter_C
Databricks Employee
Databricks Employee

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.

seckinaktas
New Contributor II

Thank you so much

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local communityโ€”sign up today to get started!

Sign Up Now