permissions.sql

GRANT SELECT, REFERENCES ON ALL TABLES IN SCHEMA public TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO <hasura-connection-string-user>;
REVOKE CREATE ON SCHEMA public FROM PUBLIC;

GRANT  USAGE ON SCHEMA hdb_catalog  TO <hasura-connection-string-user>;
GRANT ALL ON schema hdb_catalog TO <hasura-connection-string-user>;
GRANT ALL ON ALL TABLES IN SCHEMA hdb_catalog TO <hasura-connection-string-user> ;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA hdb_catalog TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_catalog GRANT ALL PRIVILEGES ON TABLES TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_catalog GRANT USAGE ON SEQUENCES TO <hasura-connection-string-user>;

GRANT  USAGE ON SCHEMA hdb_pro_catalog  TO <hasura-connection-string-user>;
GRANT ALL ON schema hdb_pro_catalog TO <hasura-connection-string-user>;
GRANT ALL ON ALL TABLES IN SCHEMA hdb_pro_catalog TO <hasura-connection-string-user> ;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA hdb_pro_catalog TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_pro_catalog GRANT ALL PRIVILEGES ON TABLES TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_pro_catalog GRANT USAGE ON SEQUENCES TO <hasura-connection-string-user>;

GRANT  USAGE ON SCHEMA hdb_views  TO <hasura-connection-string-user>;
GRANT ALL ON schema hdb_views TO <hasura-connection-string-user>;
GRANT ALL ON ALL TABLES IN SCHEMA hdb_views TO <hasura-connection-string-user> ;
GRANT USAGE ON ALL SEQUENCES IN SCHEMA hdb_views TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_views GRANT ALL PRIVILEGES ON TABLES TO <hasura-connection-string-user>;
ALTER DEFAULT PRIVILEGES IN SCHEMA hdb_views GRANT USAGE ON SEQUENCES TO <hasura-connection-string-user>;