Add full refresh to meltano permissions
Problem to solve
In the course of working with the permission script, it's clear that permission script is good for adding / confirming existing permissions, but it's not keeping things 100% in sync with the config. Meaning if I've done some additional grants outside the config those will still be there and the permission script won't catch it.
I'm proposing as an MVC a full-refresh
option which basically does a REVOKE ALL
for all privileges and roles defined in the config file, followed by all of the grants. https://docs.snowflake.net/manuals/sql-reference/sql/revoke-privilege.html
This would be a nice way to confirm that what's in the config is what's in the DB.