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.
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
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.
EmiB
Highly Voted 1 year, 8 months ago_yyukta
Most Recent 8 months, 2 weeks agoBobFar
1 year, 1 month agoMultiCloudIronMan
1 year, 4 months agolearner2023
1 year, 7 months ago