1. In Scalegrid, find the database you’re interested in. Click on “Users & DBs”

    Untitled

  2. Create a user and password, and save this in Lastpass, in the appropriate shared folder (usually Shared-Team: Technologies)

  3. In your favorite postgresql client, do the following grants, replacing the database, schema, and user with the appropriate values. In this case, we’re granting access for the metabase user to the database postgres , schema ultron. We want this user to be read-only, which is why we only grant SELECT.

    GRANT CONNECT ON DATABASE postgres TO metabase;
GRANT USAGE ON SCHEMA "ultron" TO metabase;
GRANT SELECT ON ALL TABLES IN SCHEMA "ultron" TO metabase;
GRANT SELECT ON ALL SEQUENCES IN SCHEMA "ultron" TO metabase;
ALTER DEFAULT PRIVILEGES IN SCHEMA "ultron" GRANT SELECT ON TABLES TO metabase;

  4. Test your connection to ensure you have access to what you need