英文:
Does UNDROP restore grants to the undropped object?
问题
如果一张表、架构或数据库被意外删除，然后一分钟后被还原 - 它会失去所有授予它的权限吗？
我已经阅读了Snowflake的文档，但他们似乎没有提到这一点。
英文:
If a table, schema or database is dropped accidentally, and a minute later undropped - will it lose all privileges that were granted on it?
I have read the Snowflake documentation, but they don't seem to mention that.
答案1
得分: 0
https://docs.snowflake.com/en/sql-reference/account-usage/grants_to_roles#columns
https://docs.snowflake.com/en/sql-reference/sql/undrop
英文:
The grants will be recovered along with the table, meaning the roles that had the privilege on the table/object will be available for use
https://docs.snowflake.com/en/sql-reference/account-usage/grants_to_roles#columns
https://docs.snowflake.com/en/sql-reference/sql/undrop
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论