Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Child pages (Children Display)

...

There is the following prerequisites for using scripts for creating DB schema: "openhub" user role has to defined. This role is owner of all tables and has granted all necessary privileges:

Code Block
-- grant privileges to 'openhub' user
GRANT SELECT, USAGE, UPDATE ON openhub_sequence TO openhub;
GRANT SELECT, INSERT, UPDATE, DELETE ON message, external_call, request, response, configuration TO openhub

Table message

Table for storing asynchronous messages:

...