--liquibase formatted sql
--changeset tshagapov:user_permissions_fixed runAlways:true
--other last_applied files contained wrong definition of runAlways tag

ALTER DEFAULT PRIVILEGES IN SCHEMA PUBLIC GRANT SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES ON TABLES TO chartmetric_user_proxy;
ALTER DEFAULT PRIVILEGES IN SCHEMA PUBLIC GRANT ALL ON SEQUENCES TO chartmetric_user_proxy;
ALTER DEFAULT PRIVILEGES IN SCHEMA PUBLIC GRANT SELECT ON TABLES TO chartmetric_reader_proxy;
ALTER DEFAULT PRIVILEGES IN SCHEMA PUBLIC GRANT ALL ON TABLES TO chartmetric_owner;
ALTER DEFAULT PRIVILEGES IN SCHEMA PUBLIC GRANT ALL ON SEQUENCES TO chartmetric_owner;

GRANT SELECT ON ALL TABLES IN SCHEMA public TO chartmetric_reader_proxy;
GRANT SELECT, INSERT, UPDATE, DELETE, TRUNCATE, REFERENCES ON ALL TABLES IN SCHEMA public TO chartmetric_user_proxy;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO chartmetric_user_proxy;
GRANT ALL ON ALL TABLES IN SCHEMA public TO chartmetric_owner;
GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO chartmetric_owner;