access.sql (1494B)
1 -- DO NOT EXECUTE THIS BY HAND (use migrate.sh instead) 2 BEGIN; 3 4 SELECT _v.register_patch('access', ARRAY['0001-c2ec-schema', 'proc-c2ec-payment-notification-listener', 'proc-c2ec-retry-listener', 'proc-c2ec-status-listener', 'proc-c2ec-transfer-listener'], NULL); 5 6 SET search_path TO c2ec; 7 8 -- For migration and other db management tasks 9 CREATE USER c2ec_admin WITH ENCRYPTED PASSWORD ADMIN_PASSWORD; 10 --For CLI (managing terminals and providers): 11 CREATE USER c2ec_operator WITH ENCRYPTED PASSWORD OPERATOR_PASSWORD; 12 --For the API (handling withdrawals): 13 CREATE USER c2ec_api WITH ENCRYPTED PASSWORD API_PASSWORD; 14 15 GRANT USAGE ON SCHEMA _v TO c2ec_admin; 16 GRANT ALL PRIVILEGES ON _v.patches TO c2ec_admin; 17 GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA _v TO c2ec_admin; 18 19 GRANT ALL PRIVILEGES ON DATABASE DB_NAME TO c2ec_admin; 20 21 GRANT USAGE ON SCHEMA c2ec TO c2ec_operator; 22 GRANT ALL PRIVILEGES ON c2ec.terminal TO c2ec_operator; 23 GRANT ALL PRIVILEGES ON c2ec.provider TO c2ec_operator; 24 25 GRANT USAGE ON SCHEMA c2ec TO c2ec_api; 26 GRANT ALL PRIVILEGES ON c2ec.withdrawal TO c2ec_api; 27 GRANT ALL PRIVILEGES ON c2ec.transfer TO c2ec_api; 28 GRANT SELECT ON c2ec.terminal TO c2ec_api; 29 GRANT SELECT ON c2ec.provider TO c2ec_api; 30 GRANT EXECUTE ON FUNCTION c2ec.emit_withdrawal_status TO c2ec_api; 31 GRANT EXECUTE ON FUNCTION c2ec.emit_payment_notification TO c2ec_api; 32 GRANT EXECUTE ON FUNCTION c2ec.emit_retry_notification TO c2ec_api; 33 GRANT EXECUTE ON FUNCTION c2ec.emit_transfer_notification TO c2ec_api; 34 35 COMMIT;