cidb/migrations/00027_create_annotator_user.sql

USE cidb;

FLUSH PRIVILEGES;
CREATE USER annotator
IDENTIFIED BY PASSWORD '*54C06F8BEE226565D06E0AE8151E3C7381155E9B';

GRANT SELECT on cidb.* to annotator;
GRANT SELECT, UPDATE, INSERT on cidb.annotationsTable to annotator;

FLUSH PRIVILEGES;

INSERT INTO schemaVersionTable (schemaVersion, scriptName) VALUES
  (27, '00027_create_annotator_user.sql');