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.
37ceea2
3 weeks, 1 day agoMatthieuDN
3 weeks, 6 days agoJiten732
4 weeks ago37ceea2
3 weeks, 1 day ago