Access Rights in Postgres for Proper Ingestion with Metadata

troubleshoot
1

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?

2

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…

3

<@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”;

4

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

5

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