Connector Improvement: Oracle Teleport
Answered
Can I ask why we require the following permissions for 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 Shubhankar,
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