cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Issue with View Ownership Reassignment in Unity Catalog

Filippo
New Contributor

Hello,

It appears that the ownership rules for views and functions in Unity Catalog do not align with the guidelines provided in the โ€œManage Unity Catalog object ownershipโ€ documentation on Microsoft Learn.

When attempting to reassign the ownership of a view using the catalog owner, I encounter the following error: โ€œNon-admin user can only transfer ownerships for views to groups the owner is a member of.โ€

I donโ€™t understand the logic behind why ownership for views can only be transferred 1) exclusively to groups and 2) only to groups that the user is a member of.

As the catalog owner, I would like to be able to transfer the ownership of a view from one user to another user.

Could you please provide guidance on how to resolve this issue?

Thank you.

1 ACCEPTED SOLUTION

Accepted Solutions

Satyadeepak
Databricks Employee
Databricks Employee

Hi @Filippo To prevent privilege escalations, only a metastore admin can transfer ownership of a view, function, or model to any user, service principal, or group in the account. Current owners and users with the MANAGE privilege are restricted to transferring ownership to their username or to a group that they are member of.

https://docs.databricks.com/en/data-governance/unity-catalog/manage-privileges/ownership.html#transf...

View solution in original post

1 REPLY 1

Satyadeepak
Databricks Employee
Databricks Employee

Hi @Filippo To prevent privilege escalations, only a metastore admin can transfer ownership of a view, function, or model to any user, service principal, or group in the account. Current owners and users with the MANAGE privilege are restricted to transferring ownership to their username or to a group that they are member of.

https://docs.databricks.com/en/data-governance/unity-catalog/manage-privileges/ownership.html#transf...

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