What happens when a database is cloned?

Question

Options

• AIt does not retain any privileges granted on the source object.
• BIt replicates all granted privileges on the corresponding source objects.
• CIt replicates all granted privileges on the corresponding child objects.
• DIt replicates all granted privileges on the corresponding child schema objects.

• A
  87% (26)
• B
  3% (1)
• C
  7% (2)
• D
  3% (1)

Explanation

When a database (or schema or table) is cloned in Snowflake, the clone does NOT inherit any of the privilege grants that existed on the source object. The clone is a brand-new object and starts with a clean privilege slate - only the role that performed the CLONE operation owns it. This is a critical distinction: while the cloned object contains the same data and structure as the source (via zero-copy cloning), access control grants are explicitly excluded. Options B, C, and D are all incorrect because privilege replication does not occur in any form during cloning.

No community discussion yet for this question.