CREATE USER swiftlive_read_only with PASSWORD '111111';
ALTER USER swiftlive_read_only set default_transaction_read_only = on;
GRANT CONNECT on database swiftlive_prod to swiftlive_read_only with grant option;
\c swiftlive_prod;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO swiftlive_read_only;
ALTER USER swiftlive_read_only set default_transaction_read_only = on;
GRANT CONNECT on database swiftlive_prod to swiftlive_read_only with grant option;
\c swiftlive_prod;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO swiftlive_read_only;