Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
Permissions with and without db_owner role:
Thanks!
Bill