Contents

-- Table
GRANT SELECT, INSERT ON messages TO message_store;

-- Sequence
GRANT USAGE, SELECT ON SEQUENCE messages_global_position_seq TO message_store;

-- Functions
GRANT EXECUTE ON FUNCTION gen_random_uuid() TO message_store;
GRANT EXECUTE ON FUNCTION md5(text) TO message_store;
GRANT EXECUTE ON FUNCTION hash_64(varchar) TO message_store;
GRANT EXECUTE ON FUNCTION category(varchar) TO message_store;
GRANT EXECUTE ON FUNCTION stream_version(varchar) TO message_store;
GRANT EXECUTE ON FUNCTION write_message(varchar, varchar, varchar, jsonb, jsonb, bigint) TO message_store;
GRANT EXECUTE ON FUNCTION get_stream_messages(varchar, bigint, bigint, varchar) TO message_store;
GRANT EXECUTE ON FUNCTION get_category_messages(varchar, bigint, bigint, varchar) TO message_store;
GRANT EXECUTE ON FUNCTION get_last_message(varchar) TO message_store;

-- Views
GRANT SELECT ON category_type_summary TO message_store;
GRANT SELECT ON stream_summary TO message_store;
GRANT SELECT ON stream_type_summary TO message_store;
GRANT SELECT ON type_category_summary TO message_store;
GRANT SELECT ON type_stream_summary TO message_store;
GRANT SELECT ON type_summary TO message_store;

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
evt-message_store-postgres-database-1.1.0.2	database/user/privileges.sql
evt-message_store-postgres-database-1.1.0.1	database/user/privileges.sql
evt-message_store-postgres-database-1.1.0.0	database/user/privileges.sql
evt-message_store-postgres-database-1.0.0.0	database/user/privileges.sql
evt-message_store-postgres-database-0.11.0.0	database/user/privileges.sql
evt-message_store-postgres-database-0.10.1.3	database/user/privileges.sql
evt-message_store-postgres-database-0.10.1.2	database/user/privileges.sql
evt-message_store-postgres-database-0.10.1.1	database/user/privileges.sql