When you use the COPY GRANTS clause in a CREATE … CLONE statement, Snowflake copies all explicit access privileges that were granted on the source object to the new clone, but does not copy the OWNERSHIP privilege. The clone’s ownership is assigned to the role executing the CLONE command, and any future grants defined at the schema level are not applied to that clone.
Jiten372 is right
https://docs.snowflake.com/en/user-guide/object-clone
When the COPY GRANTS parameter is specified in a CREATE TABLE statement, the create operation copies all privileges, except OWNERSHIP, from the source table to the new table. The same behavior is true for other CREATE commands that support the COPY GRANTS clause.
I think B is correct unless OWNERSHIP is not an "explicit" privilege https://docs.snowflake.com/en/sql-reference/sql/create-clone#:~:text=If%20the%20COPY%20GRANTS%20parameter%20is%20used%2C%20then%20the%20new%20object%20inherits%20any%20explicit%20access%20privileges%20granted%20on%20the%20original%20table
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Billhardy
1 week, 6 days ago37ceea2
3 months agoMatthieuDN
3 months agoJiten732
3 months, 1 week ago37ceea2
3 months ago