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

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group