User pavan does not have access to CDC schema in the following databases: sampleDB. This user can only be used in initial_only snapshot mode

[Muniganti Pavan]

Hi Team, 

im getting an issue while creating a debezium connector for sql server. 

even though i have provided the cdc schema access with these commands,

--USE sampleDB;
--GRANT SELECT, INSERT, UPDATE, DELETE ON schema::cdc TO pavan;

i still see this error : 
User pavan does not have access to CDC schema in the following databases: sampleDB. This user can only be used in initial_only snapshot mode

I would appreciate if someone could help me on this?

Thanks.

[Chris Cranford]

Hi -

Have you enabled SQL Server's CDC for at least one table in your connector's configuration?  Typically this happens when you have defined tables and configured Debezium to capture those tables but you have not yet enabled table-level CDC for those tables, and so no capture instances yet exist.

If you execute the "sys.sp_cdc_help_change_data_capture" stored procedure for your database and it returns no results, then no table has yet been configured for CDC and Debezium will continue to report this error until at least you have some result returned. 

Hope that helps.
Chris

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/00a21bbe-c528-4a3b-92de-3da0ab19c08fn%40googlegroups.com.

[Aqhil Mohammad]

Hello, it's known issue in SQL Server. What you need is to enable CDC on tables and mention CDC role in the  Stored procedure of CDC enable. Provide select privileges on cdc.capture and cdc.colums on selected tables.

Thanks,

Akhil.

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/d13c3d7d-54db-4dc6-b038-14303f52edf1%40gmail.com.