CODEWITHSUNDEEP
sharesnowflake-cloud-data-platform
Ram
Ram

Reputation: 61

snowflake change owner of a share from accountadmin to another role?

We create many shares with accountadmin.

Now we granted 'create shares' to sysadmin, how can i change the ownership of previous shares to sysadmin without drop and recreate the share?

Upvotes: 2

Views: 1322

Answers (1)

Rajib Deb
Rajib Deb

Reputation: 1774

I think currently

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.

Also Ownership of a share cannot be transferred to another role

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.

The only option will be to drop and recreate the share

Upvotes: 2

Related Questions