Skip to content

Instantly share code, notes, and snippets.

@denzhel

denzhel/snowflake_delete_table.md

Created December 11, 2022 22:08
Show Gist options
  • Save denzhel/0d10983e8811ee55015b9b18f4cca74f to your computer and use it in GitHub Desktop.
Save denzhel/0d10983e8811ee55015b9b18f4cca74f to your computer and use it in GitHub Desktop.
Download ZIP
snowflake delete table privilege
Raw
snowflake_delete_table.md

To allow roles to delete talbes in a specific database.schema:

grant DELETE TABLE on <dbName>.<schmeaName> to role <roleName>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment