1-- this file is run by test/create_db.sh to create users for each 2-- component with the appropriate permissions. 3 4-- These lines require MariaDB 10.1+ 5CREATE USER IF NOT EXISTS 'incidents_sa'@'localhost'; 6CREATE USER IF NOT EXISTS 'test_setup'@'localhost'; 7 8-- Storage Authority 9GRANT SELECT ON * TO 'incidents_sa'@'localhost'; 10 11-- Test setup and teardown 12GRANT ALL PRIVILEGES ON * to 'test_setup'@'localhost';