Skip to main content

​
Creating a service account

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;

​
Granting Access if Another User Will Run DDL

For all other users that will run CREATE TABLE statements please run 
-- 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;

​
Turning on logical replication

rds.logical_replication is a static parameter which requires a database reboot to take effect.
  1. Select your database instance
  2. Go into Configuration and find your DB instance parameter group (or DB cluster parameter group if you are using Aurora)
  3. If you don’t have one, go to Parameter groups and click Create parameter group
Create parameter group
  1. Find and change rds.logical_replication and set it to 1
Change rds.logical_replication to 1
  1. Associate the parameter group with your database instance
Associate parameter group to your database instance