How to Limit Fivetran Permissions in the Destination

Environment

Destinations

Use Case

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.

Recommendations

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.

Considerations

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.