- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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
Thank you
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
โ11-21-2024 05:50 AM - edited โ11-21-2024 05:51 AM
Thank you so much

