Connector Improvement: Connector Improvement: Connector for CrunchTime Oracle database
Can I ask why we require the following permissions to use Teleport
GRANT CREATE TYPE TO FIVETRAN;
GRANT CREATE PROCEDURE TO FIVETRAN;
Because as per the documentation you only require a read only SQL connection.
-
Official comment
Hi,
I noticed you posted this question twice, so I'll link to the other thread here: https://support.fivetran.com/hc/en-us/community/posts/5736974449175-Connector-Improvement-Oracle-Teleport-
For others' reference below is my response!
We require these grants to run 3 functions that are required to do the row-by-row comparison which Teleport uses. This comparison is necessary for us to quickly find differences in rows between different snapshots.
If these grants are not permitted, there is also a way to set up these scripts manually in the database which will also allow Teleport to run. For other DBs, there are native functions that we leverage, unfortunately for Oracle, these functions do not exist so we use this permission to create those functions!
Please let me know if you have any other questions.
Kevin
Please sign in to leave a comment.
Comments
1 comment