What happens when a database is cloned?
What happens when a database is cloned?
When a database is cloned, it replicates all granted privileges on the corresponding child objects. This means the privileges that were granted on the individual objects within the database (such as tables, schemas, and views) are copied to the clone. However, the clone does not inherit any privileges granted on the database container itself.
If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object: For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc. Note that the clone of the container itself (database or schema) does not inherit the privileges granted on the source container.
C. It replicates all granted privileges on the corresponding child objects
If the source object is a database or schema, the clone inherits all granted privileges on the clones of all child objects contained in the source object: For databases, contained objects include schemas, tables, views, etc. For schemas, contained objects include tables, views, etc. Note: 1) The clone of the container itself (database or schema) does not inherit the privileges granted on the source container. 2) In all other cases, you must grant any required privileges to the newly-created clone (using GRANT <privileges>). https://docs.snowflake.com/en/user-guide/object-clone#access-control-privileges-for-cloned-objects
correct
https://docs.snowflake.com/en/user-guide/object-clone