DDL replication without db_owner role

ott — Wed, 18 Jan 2023 12:40:25 GMT

Hi,
we would like to to set up DDL replication from SQL Server (MS-CDC) witout granting db_admin role. We create needed db objects manually.
We got rid of [dbo].[attrep_mscdc_ddl_history]-related error, but for trigger [attrep_mscdc_ddl_catcher] we continue getting error "Cannot create the trigger 'attrep_mscdc_ddl_catcher', because you do not have permission." although the trigger is created already manually. Any ideas what could be wrong?

Re: DDL replication without db_owner role

Bill_Steinagle — Wed, 18 Jan 2023 13:48:48 GMT

@ott

Hello and thank you for the post to the QDI Forums. As a first step I would suggest looking over the below UG details for the setup and the permissions as needed for the non-admin user. Also see the note as shown in the below link about the permissions without the Admin Role.

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/MicrosoftSQLServer-MSCDC/MicrosoftSQLServer-MSCDC-limitations.htm

Permissions with and without db_owner role:

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedReplicateHDD/Azure-MSCDC-Source/azremscdc-SQLServerDBSource-security.htm

Thanks!

Bill

topic Re: DDL replication without db_owner role in Qlik Replicate

DDL replication without db_owner role

Re: DDL replication without db_owner role