-- Execute as the database administrator AFTER importing schema.sql.
-- Replace the password below; do not use it literally.
CREATE USER 'jhasi_app'@'localhost' IDENTIFIED BY 'REPLACE_WITH_A_RANDOM_DATABASE_PASSWORD';
GRANT SELECT, INSERT, UPDATE ON jhasi_assessment.users TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT, UPDATE ON jhasi_assessment.assessments TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.attachments TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.case_events TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.audit_log TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT, UPDATE ON jhasi_assessment.login_limits TO 'jhasi_app'@'localhost';

GRANT SELECT, UPDATE ON jhasi_assessment.programme_settings TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.settings_history TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.incentive_ledger TO 'jhasi_app'@'localhost';
GRANT SELECT, INSERT ON jhasi_assessment.quality_checks TO 'jhasi_app'@'localhost';