I wanted to check whether the ownership of a schema can be restricted from being inherited by another role. I have a managed schema, which is owned (has ownership privilege granted to it) by a role A. Role B inherits Role A, but I do not want Role B to inherit the ownership privilege.

我想检查是否可以限制架构的所有权不被另一个角色继承。我有一个托管架构，它由角色A拥有(具有所有权特权)。角色B继承角色A，但我不希望角色B继承所有权特权。

Is this setup possible at all within snowflake? That is, can we say that in this situation, the schema has two owners, or only one owner?

这种设置在雪花中可能吗？也就是说，在这种情况下，我们可以说模式有两个所有者，还是只有一个所有者？

I have setup the inheritance for Role A to Role B, and it says that the both the roles have ownership privilege, and Role B got its ownership via inheritance from Role A.

我已经设置了角色A到角色B的继承，它表明这两个角色都具有所有权特权，而角色B通过继承角色A来获得其所有权。

No it is not possible to set up Role B to inherit from Role A except in the one specific circumstance of ownership of a specific schema.

不，不可能将角色B设置为继承角色A，除非是在拥有特定架构的特定情况下。

You need to re-think your role design in order to achieve the end result you want

你需要重新考虑你的角色设计，以达到你想要的最终结果