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
你需要重新考虑你的角色设计,以达到你想要的最终结果
更多回答
我是一名优秀的程序员,十分优秀!