How Can I Restrict the Fivetran User's SELECT Permissions to Specific Schemas in MariaDB?

Question

Our security policy only allows granting SELECT permissions on specific schemas, rather than globally. How can I configure this for the MariaDB Fivetran user I created?

Environment

Connector: MariaDB

Answer

To configure a Fivetran user in MariaDB with SELECT permissions on specific schemas, do the following:

Replace all placeholders, such as <username>, <password>, and <schema>, with the actual values.

Create the Fivetran user:

CREATE USER '<username>'@'%' IDENTIFIED BY '<password>';

Grant the required replication privileges:

GRANT REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO '<username>'@'%';

Grant SELECT permissions on each schema you want to sync:
```
GRANT SELECT ON <schema>.* TO '<username>'@'%';
```