Access Rights in Postgres for Proper Ingestion with Metadata

Original Slack Thread

Hi All, could sombody explane me about necessary acces rights in Postgres (minimum rights) for the ingestion proper work only with metadata?

The minimum privilage is “select” for datahub user to all databases that you would like to ingest the metadata into Datahub if my memory is correct…

<@U05B3RG1PD1> I make some test and the minimum rights is GRAND USAGE on Schema… like this: GRANT USAGE ON SCHEMA datahub to “user”;
GRANT USAGE ON SCHEMA public to “user”;

in this case not necessary give to much rights to the datahub user

be couse it is dongerous to consolidate at least ~300 database users with select rights in one place.