-- this file is run by test/create_db.sh to create users for each
-- component with the appropriate permissions.

-- These lines require MariaDB 10.1+
CREATE USER IF NOT EXISTS 'incidents_sa'@'%';
CREATE USER IF NOT EXISTS 'test_setup'@'%';

-- Storage Authority
GRANT SELECT ON * TO 'incidents_sa'@'%';

-- Test setup and teardown
GRANT ALL PRIVILEGES ON * to 'test_setup'@'%';
