Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
ott
Contributor
Contributor
‎2023-01-18 07:40 AM

DDL replication without db_owner role

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?

849 Views
0 Likes
1 Reply
Bill_Steinagle
Support
Support
‎2023-01-18 08:48 AM

@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/M...

Permissions with and without db_owner role:

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedReplicateHDD/...

 

Thanks!

Bill

827 Views