0

By default when i connect Hasura to a postgres database, it connects to the public schema.

Isn't there an option to connect to a different schema?

thanikkal
  • 3,326
  • 3
  • 27
  • 45

1 Answers1

0

Hasura needs 2 schemas to work: hdb_catalog and hdb_views.

All other schemas are optional.

You can register objects from any schema if hasurauser has access to them.

schemas-in-hasura

Alex Yu
  • 3,412
  • 1
  • 25
  • 38
  • Thanks. By default, when a database usage grant was given to the graphgl_postgres user, it only have access to public. after granting permission to other shema, they are now visible on the console. Thank you! – thanikkal Sep 21 '21 at 04:33
  • 1
    Hasura has access to `public` only because you followed installation instructions, in theory nothing prevents you to not give rights on `public` or even use hasura only as aggregator for remote schemas. – Alex Yu Sep 21 '21 at 05:15