Skip to content

Instantly share code, notes, and snippets.

@cassioeskelsen

cassioeskelsen/ativando_cdc.sql

Created April 10, 2022 23:44
Show Gist options
  • Save cassioeskelsen/233a63daf81e5e8218cfe50feff7632d to your computer and use it in GitHub Desktop.
Save cassioeskelsen/233a63daf81e5e8218cfe50feff7632d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ativando_cdc.sql
EXEC sys.sp_cdc_enable_db
GO
/*Criar uma role para o usuário debezium: */
CREATE ROLE CDC_Reader
GO
/*Criar um usuário para leitura do CDC: */
CREATE USER [debezium-cdc] WITH PASSWORD = '<senha>'
GO
ALTER ROLE [CDC_Reader] ADD MEMBER [debezium-cdc]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment