You want to limit permissions for a Fivetran user that writes data into your destination. By default, the user has full access at the database level. You want the user to only have access to specific schemas or datasets.
When you recreate permissions in your destination, you must preserve the Fivetran user’s ability to write data, which includes the following:
- Creating new schemas and tables
- Creating temporary tables
- Altering tables
Fivetran uses temporary tables that are named with a random string. When you recreate permissions, you must ensure that the Fivetran user has access to all future tables created in the schemas we write to.
NOTE: The command that grants access to future tables is different for each destination.
Implementing specific permissions requires additional maintenance of your connectors. You must ensure that user permissions are continually updated so that the Fivetran user in your destination can create and update new schemas and tables as they are added from various sources.