...
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:
...