雪花将共享的所有者从accountadmin更改为另一个角色



我们使用accountadmin创建了许多共享。

现在我们将"创建共享"授予了sysadmin,我如何在不删除和重新创建共享的情况下将以前共享的所有权更改为sysadmin?

我认为目前

The ACCOUNTADMIN role has the privileges to create a share.
You can also grant CREATE SHARE and IMPORT SHARE to other roles, enabling the tasks to be delegated to other users in the account. For more information, see Enabling non-ACCOUNTADMIN Roles to Perform Data Sharing Tasks.

此外,股份所有权不能转让给另一个角色

Ownership of a share, as well as the objects in the share, may be either through a direct grant to the role or inherited from a lower-level role in the role hierarchy. For more details, see Role Hierarchy and Privilege Inheritance.
Also, it’s possible for the same role to own a share and the objects in the share.

唯一的选择是删除并重新创建共享

最新更新