Hi Airbyte team, what access does the airbyte user need on an external database? Also, is there a sql script to generate this user? edit1: FYI i am using PG 13.4 on AWS RDS. edit2: I am talking about this btw

Hey it would need read and write access as we will be storing the configs and other things (temporal) etc there.

Hi Harshith, yeah could be more specific about the sql access permissions? I saw the read write access but that is kind of vague and not helpful when creating the airbyte role/user in postgres. So does it need read write at the whole db level? On what schemas does it need access? Does it need to be a superuser? I also ran into issues where the role needs to be the owner of some tables since the

ALTER

command is run. It would easiest if you could tell me the specific permissions the role would need. Right now I am just granting the same permissions as the root user to airbyte (

GRANT root TO airbyte

) which is not ideal since the airbyte user should have only access to what it needs to rather than everything. I think the easiest solution is for you to give me a short 3 or 4 line SQL script that creates some role with the proper permissions.

Hey generally we were giving full permissions but have requested the team if we have anything more specific on this. Waiting for team to get back.

Hi @Harshith (Airbyte) is there an update on this?

From

select * from information_schema.role_table_grants where grantee='docker';

insert, select, update, delete, truncate, references

select * from pg_tables where tableowner = 'docker';

tableowner

basically the airbyte users needs to be an admin to create or delete data, and be able to create the right schemas.