Amazon Aurora and RDS

CREATE USER artie_transfer WITH PASSWORD 'password';

GRANT USAGE ON SCHEMA schema_name TO artie_transfer;
-- Grant access to existing tables
GRANT SELECT ON ALL TABLES IN SCHEMA schema_name TO artie_transfer;
-- Grant read-only access to future tables created by current user
ALTER DEFAULT PRIVILEGES IN SCHEMA schema_name GRANT SELECT ON TABLES TO artie_transfer;

-- The replication role does not have enough permissions to create publications.
-- So you will need to create this as well.
CREATE PUBLICATION dbz_publication FOR ALL TABLES WITH (publish_via_partition_root = true);

-- Grant replication role
GRANT rds_replication to artie_transfer;

-- Grant read-only access to future tables for given user
ALTER DEFAULT PRIVILEGES FOR ROLE given_user IN SCHEMA schema_name GRANT SELECT ON TABLES TO artie_transfer;