CockroachDB

-- If you are on major version 22
CREATE USER artie WITH LOGIN PASSWORD 'your-password' CONTROLCHANGEFEED VIEWCLUSTERSETTING;

-- If you are on major version 23+
CREATE USER artie WITH LOGIN PASSWORD 'your-password' VIEWCLUSTERSETTING;

GRANT USAGE ON SCHEMA "public", "your_schema" TO artie;
GRANT SELECT ON ALL TABLES IN SCHEMA "public", "your_schema" TO artie;
ALTER DEFAULT PRIVILEGES IN SCHEMA "public", "your_schema" GRANT SELECT ON TABLES TO artie;

SHOW ZONE CONFIGURATION FROM DATABASE your_database;

-- Setting GC TTL to 12 hours
ALTER DATABASE your_database CONFIGURE ZONE USING gc.ttlseconds = 43200;

SET CLUSTER SETTING kv.rangefeed.enabled = true;
SET CLUSTER SETTING feature.changefeed.enabled = true;