Script designed to simplify the management of permissions in your Snowflake databases.
With this tool, you can effortlessly revoke all permissions granted to existing objects, as well as future objects. Additionally, it modify object ownership by assigning them to another role (by default SYSADMIN).
Please, check the instructions before executing the command line :
python -m snow_revoke_privileges
The project uses pip as package installer.
A configuration file named config.yaml must be created using the same format as config-example.yaml.
You have to use an account with the permissions to REVOKE PRIVILEGE and GRANT OWNERSHIP.
The following extensions are recommanded:
- AutoDocstring - Python Docstring Generator
- Prettify JSON
- Pylance
- Python
- Python Type Hint
- Todo Tree
- VSCode-icons
The file .vcode/settings.json was updated with my own configuration.
Enjoy!